题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select
g1.id,
name,
score
from (
select
id,
language_id,
score,
dense_rank() over (partition by language_id order by score desc)
as rank_num
from grade
) as g1
join language
on g1.language_id = language.id
where rank_num <=2
order by name,score desc,g1.id
