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

建表语句点击详见

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

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;