每个学生每个科目最近考试时间

每个学生每个科目最近考试时间

SELECT s.studentname,g.gradeName,b.subjectName,a.examDate,a.result FROM(
SELECT a.studentNO,a.subjectNo,MAX(examDate) examdate,MAX(studentresult) result
FROM result a
GROUP BY a.studentNo,a.subjectNo) a
INNER JOIN student s ON s.studentno = a.studentno
INNER JOIN grade g ON g.gradeId = s.gradeId
INNER JOIN SUBJECT b ON b.subjectno = a.subjectno