题解 | #考试分数(三)#

select g.id,name,score
from(select *,dense_rank() over (partition by language_id order by score desc) r from grade) g
inner join language l
on l.id=g.language_id
where r<=2
order by name asc,score desc,g.id asc