题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#

select date,user_id,pass_count from (
select date,user_id,pass_count,row_number() over(partition by date order by pass_count desc) rn from questions_pass_record ) t1
where rn <=2