题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select a.id,a.name,a.score from (select g.id,l.name,g.score,dense_rank() over(partition by g.language_id order by score desc) rank_ from grade g left join language l on g.language_id=l.id ) a where rank_<3 order by a.name,a.score desc,a.id
- 考察窗口函数的使用
查看20道真题和解析