SQL 查询各班级各科前三名学生成绩

SELECT 班级, 科目, 姓名, 成绩 FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY 班级, 科目 ORDER BY 成绩 DESC) AS rank FROM 考试成绩 ) AS temp WHERE rank <= 3 ORDER BY 班级, 科目, rank;