题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select hh.id,name ,score
from(
select *,dense_rank()over(partition by language_id order by score desc) rk
from grade
) hh ,language l
where (rk=1 or rk=2) and l.id=hh.language_id
order by name,score DESC,hh.id
from(
select *,dense_rank()over(partition by language_id order by score desc) rk
from grade
) hh ,language l
where (rk=1 or rk=2) and l.id=hh.language_id
order by name,score DESC,hh.id
