题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
SELECT a.id, b.name, a.score FROM ( SELECT id, language_id, score, DENSE_RANK() OVER (partition by language_id order by score desc ) pai FROM grade ) a LEFT JOIN language b ON a.language_id=b.id WHERE a.pai<3 ORDER BY b.name,a.score desc
运用开窗函数分组排序并记录排名，再用where过滤即可
Momenta公司福利 484人发布
真的是验证了只要肯吃苦就有吃不完的苦这句话。。