题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
开窗函数dense_rank 的用法
select id,name,score from ( select tb1.id ,tb2.name,score, dense_rank()over(partition by tb2.name order by score desc)frank from grade tb1 inner join language tb2 on tb1.language_id=tb2.id )a where frank =1 or frank =2 order by name,score desc ,id