npertuset Posted June 17, 2011 Share Posted June 17, 2011 I'm having an SQL query issue. I think I need to self join, but I can't exactly figure out what to do. I have a table that keeps track of student exams. ID is the unique ID, studentno is the student ID number, moduleid is the course id, sitting is each time they took the exam (they can take an exam for a course as many times as they want) and grade is their grade. I just need to select the studentno, moduleid, sitting and grade for each student/course, but I only want to display the final sitting (See this for example: http://pastebin.com/X1ELnFa2) Quote Link to comment https://forums.phpfreaks.com/topic/239609-db-query/ Share on other sites More sharing options...
fugix Posted June 17, 2011 Share Posted June 17, 2011 do you have any code to show? Quote Link to comment https://forums.phpfreaks.com/topic/239609-db-query/#findComment-1230876 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.