题解 | 查询每天刷题通过数最多的前二名用户id和刷题数
select
date,
user_id,
pass_count
from
(
select
date,
user_id,
pass_count,
rank() over (
partition by
date
order by
pass_count desc
) 排序
from
test.questions_pass_record
) a
where
排序 <= 2
order by
date asc