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

select
    date,
    user_id,
    pass_count
from (
        select
            date,
            user_id,
            pass_count,
            dense_rank() over(partition by date order by pass_count desc) as rk
        from 
            questions_pass_record
) a
where 
    rk <= 2