题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select g.id,l.name,g.score
from grade g
inner join language l
on g.language_id=l.id
where g.score in (
select score
from (
select distinct score
from grade
where language_id=g.language_id
order by score desc
limit 2
) t
)
order by l.name,g.score desc,g.id;
投递去哪儿旅行等公司6个岗位