每个学生每个科目最近考试时间
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
每个学生每个科目最近考试时间
最新推荐文章于 2021-01-28 04:48:19 发布