题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#
查询每天刷题通过数最多的前二名用户id和刷题数
https://www.nowcoder.com/practice/b9cc0d5047f94bc0a661c5a0a230b9cd
select date, user_id, pass_count from ( select date, user_id, pass_count, RANK() over ( PARTITION BY date order by pass_count desc ) rk from questions_pass_record ) as qpr where qpr.rk <= 2
窗口函数
给原表加一列rank排名(rk),最后用rk筛选一下(好难哦)
刷题!刷题! 文章被收录于专栏
刷题一键转化~~