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

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筛选一下（好难哦）