– 查询每门课程成绩最好的前两名
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;
– 查询每门课程成绩最好的前两名
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;