SQL273热题解答
查找每个岗位排名前两位的用户，输出相关信息---建立临时表，使用窗口函数，最后使用where对窗口函数写条件语句
select t.id, l.name, t.score from
(
select *, dense_rank()over(partition by language_id order by score DESC)rk from grade
)t join language as l on t.language_id = l.id
where t.rk in ('1', '2')
order by l.name, t.score DESC, t.id
#笔试#
查看12道真题和解析