题解 | 考试分数(三)
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
-- dense_rank() over(): 11223（同分不跳过），rank over():111446 with t1 as(select g.id, l.name, g.score, dense_rank() over(partition by l.name order by g.score desc) rk -- order by【必需】指定在每个分组中按哪个（些）列的值排序。 from grade as g inner join language as l on g.language_id = l.id) select id, name, score from t1 where rk <= 2 order by name asc, score desc, id asc;
