题解 | #查询每天刷题通过数最多的前二名用户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
            ) AS rank_num
        FROM
            questions_pass_record
    ) AS derived_table
WHERE 
    rank_num <= 2
ORDER BY
    date
;