题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
SELECT g.id,l.name,g.score
FROM
(SELECT id,language_id,score,
DENSE_RANK() OVER(PARTITION BY language_id ORDER BY score DESC) AS rk
FROM grade) g
LEFT JOIN language l ON l.id = g.language_id
WHERE g.rk <= 2
ORDER BY l.name,g.score DESC,g.id开个窗口函数 DENSE_RANK 1,1,1,2 排名
得物app公司福利 409人发布
查看11道真题和解析