题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
#思路：根据每种语言分组排序（用dense_rank），跟第二张表连接，取出排序<=2的数据即可。 select tb1.id, name, score from (select id, language_id, score, dense_rank()over(partition by language_id order by score desc) r from grade) as tb1 left join language on tb1.language_id=language.id where r<=2 order by name, score desc, id
