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

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