题解 | 考试分数(三)
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
SELECT
g.id,
l.name,
score
FROM grade g
LEFT JOIN language l ON g.language_id = l.id
RIGHT JOIN (
SELECT
id,
DENSE_RANK() OVER (PARTITION BY language_id ORDER BY score DESC) AS ranks
FROM grade
) a ON a.id=g.id
WHERE ranks <= 2
ORDER BY l.name,score DESC ,g.id
查看27道真题和解析