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

select
    date,
    user_id,
    pass_count
from
    (
        select
            user_id,
            pass_count,
            date,
            row_number() over(
                partition by
                    date
                order by
                    pass_count DESC
            ) as rnk
        from
            questions_pass_record
    ) t
where
    rnk <= 2
order by
    date

1、注意对日期分组，partition by date；2、窗口函数是函数，要带英文括号，所以是row_number()