题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#
查询每天刷题通过数最多的前二名用户id和刷题数
https://www.nowcoder.com/practice/b9cc0d5047f94bc0a661c5a0a230b9cd
select
t.date,
t.user_id,
t.pass_count
from
(select
date,
user_id,
pass_count,
row_number() over(partition by date order by pass_count desc) as pass_rank
from
questions_pass_record) t
where
t.pass_rank < 3
order by
t.date,t.pass_count desc
文远知行公司福利 522人发布
