题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#
查询每天刷题通过数最多的前二名用户id和刷题数
https://www.nowcoder.com/practice/b9cc0d5047f94bc0a661c5a0a230b9cd
select date,user_id,pass_count
from
(select
user_id,date,pass_count,
rank()over(partition by date order by pass_count desc) as rank_everyday
from questions_pass_record
)a
where rank_everyday = 1 or rank_everyday = 2
order by date asc