题解 | 考试分数(三)

-- dense_rank() over(): 11223（同分不跳过），rank over():111446
with t1 as(select g.id, l.name, g.score, dense_rank() over(partition by l.name order by g.score desc) rk -- order by【必需】指定在每个分组中按哪个（些）列的值排序。
from grade as g
inner join language as l
on g.language_id = l.id) 
select id, name, score from t1
where rk <= 2
order by name asc, score desc, id asc;