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

select
    `date`,
    user_id,
    pass_count
from
    (
        select
            `date`,
            user_id,
            pass_count,
            rank() over (
                partition by
                    `date`
                order by
                    pass_count desc
            ) as ranking
        from
            questions_pass_record
    ) as tp
    where ranking <= 2
    order by `date` asc;