题解 | 考试分数(三)

 --如果有并列第一的情况，那么第三个名应该是不包含才对，测试用例不严谨
 select  k.id,a.name,k.score from 
 (select  t.id,t.language_id,t.score,t.rn from (select  id,language_id,score,dense_rank() over(partition by language_id order by score desc) rn 
 from grade) t where t.rn<3) k 
left join language a  on k.language_id=a.id
 order by  a.name,k.score desc,k.id