题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select a.id,b.name,a.score from( select id,language_id,dense_rank() over(partition by language_id order by score desc)as rn,score from grade )a,language b where rn<=2 and a.language_id=b.id order by name asc,score desc