题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
with inter as (select g.id
, l.name
, g.score
from grade g
inner join language l on g.language_id = l.id)
select id, name, score
from (select *
, dense_rank() over (partition by name order by score desc ) as dr
from inter) f
where dr <= 2
order by name, score desc, id;