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

### 切忌是分数排名前两名的，按分数排名，相同分数取同一名次，而且连续排名，不跳序。
   select id,
          name,
          score 
     from (
   select A.id,
          B.name,
          A.score,
          dense_rank() over(partition by B.name order by A.score desc) rn 
     from grade A join language B on A.language_id = B.id 
        ) C 
        where rn <= 2 
        order by name,score desc,id;