题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
select user_id,max(countdate) max_consec_days from (select user_id,count(初始日期) countdate from (select fdate,user_id,row_number()over(partition by user_id order by fdate) countid,date_sub(fdate,interval row_number()over(partition by user_id order by fdate) day) 初始日期 from tb_dau) A group by user_id,初始日期) C group by user_id
