题解 | 查询每天刷题通过数最多的前二名用户id和刷题数
查询每天刷题通过数最多的前二名用户id和刷题数
https://www.nowcoder.com/practice/b9cc0d5047f94bc0a661c5a0a230b9cd
select date, user_id, pass_count from (select *, row_number() over(partition by date order by pass_count desc) rn from (select date,user_id,sum(pass_count) pass_count from questions_pass_record group by date,user_id) sum_pass_count ) pass_count_order where rn<=2 order by date
庆祝自己手撕完的第一个窗口函数~然后要去上课了QAQ
