题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
select user_id,max(date) max_consec_days from ( select user_id,count(1) date from ( select user_id,fdate-dense_rank()over(partition by user_id order by fdate) ranking from tb_dau where year(fdate) = '2023') as t1 group by user_id,ranking) as t2 group by user_id
，再说不用上高数吗？