查询每门课程成绩最好的前两名

建表语句点击详见

– 查询每门课程成绩最好的前两名

SELECT 

sc.c_id,
sc.s_score 

FROM score sc WHERE (
SELECT COUNT(*) FROM score WHERE sc.c_id = score.c_id AND sc.s_score<score.s_score
)<2 ORDER BY sc.c_id ASC,sc.s_score DESC;