题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#
查询每天刷题通过数最多的前二名用户id和刷题数
https://www.nowcoder.com/practice/b9cc0d5047f94bc0a661c5a0a230b9cd
select
`date`,
user_id,
pass_count
from
(
select
`date`,
user_id,
pass_count,
rank() over (
partition by
`date`
order by
pass_count desc
) as ranking
from
questions_pass_record
) as tp
where ranking <= 2
order by `date` asc;
查看5道真题和解析