题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#
查询每天刷题通过数最多的前二名用户id和刷题数
https://www.nowcoder.com/practice/b9cc0d5047f94bc0a661c5a0a230b9cd
SELECT t1.date, t1.user_id, t1.pass_count FROM ( SELECT *, RANK() OVER(partition by date ORDER BY pass_count desc) AS rk FROM questions_pass_record ) AS t1 WHERE t1.rk <= 2
