题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
WITH g AS(select *
from (select *
,DENSE_RANK() over(partition by language_id order by score desc) r_s
from grade) r
where r_s<=2
)
SELECT g.id,l.name,score
FROM g JOIN language l ON g.language_id=l.id
order by name,score desc,id
