题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select
a.id
,a.name
,a.score
from (
select
g.id
,l.name
,g.score
,dense_rank() over(partition by l.name order by g.score desc) r
from grade g
join language l
on g.language_id = l.id
) a
where a.r <= 2
查看9道真题和解析
尤其是“对战，总负责人”啊这些套职，基本上队员，打杂的都这么写
无论你签了哪家都会有些鸽offer的风险