题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
select user_id,max(in_day) max_consec_days
from(
select user_id,
count(*) as in_day
from
(select
fdate,user_id,
date_sub(fdate,interval row_number() over (partition by user_id order by fdate) day ) as '分组日期'
from tb_dau where fdate between '2023-1-1' and '2023-1-31') as it
group by user_id,分组日期) as ti
group by user_id;
