题解 | 考试分数(三)
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select id,name,score from (select id,name,score, dense_rank() over(partition by name order by score DESC) as rk from (select A.id,B.name,A.score from grade A left join language B on A.language_id = B.id) as C) as D where rk = 1 or rk = 2 order by name ASC,score DESC,id ASC
