题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
select user_id ,max(连续登陆天数) max_consec_days from (select user_id, count(*) as 连续登陆天数 from (select user_id, fdate, date_sub(fdate,interval row_number() over(partition by user_id order by fdate) day) 相对 from tb_dau) as t1 group by user_id,相对) t2 group by user_id ; 真是太难了，看着大佬的摸索出来的
查看5道真题和解析
