题解 | #注册当天就完成了试卷的名单第三页#
注册当天就完成了试卷的名单第三页
https://www.nowcoder.com/practice/718d36d2667b48faa2168b6c1521816a
-- 窗口函数限制排名也可以,只不过需要用最大分数排名
select
uid,
level,
register_time,
max_score
from
(select
uid,
level,
register_time,
max(score) max_score,
row_number()over(order by max(score) desc) rn
from exam_record
left join user_info using(uid)
left join examination_info using(exam_id)
where tag='算法' and job='算法'
and date(register_time)=date(submit_time)
group by
uid,
level,
register_time
) t
where rn>6 and rn<10
查看4道真题和解析