Jump to content

DB Query


npertuset

Recommended Posts

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)

Link to comment
https://forums.phpfreaks.com/topic/239609-db-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.