题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
with temp_table as(
select g.id ,l.name,g.score
from grade g,language l
where g.language_id=l.id
)
select a.id,a.name ,a.score from(
SELECT *,
dense_rank() OVER (PARTITION BY name ORDER BY score DESC) AS row_num
FROM temp_table
) a where a.row_num <=2
查看17道真题和解析