题解 | 考试分数(三)
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
SELECT b.id,a.name,b.score
FROM language a
LEFT JOIN(
SELECT id,language_id,score,DENSE_RANK() OVER(partition by language_id order by score desc) s_rank
FROM grade
) b
ON a.id = b.language_id
WHERE b.s_rank < 3
ORDER BY a.name,b.score DESC,b.id
查看6道真题和解析