题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
with temp as
(
select
fdate,
user_id,
row_number() over (partition by user_id order by fdate asc) as idx
from tb_dau
where fdate between '2023-01-01' and '2023-01-31'
)
select
user_id,
max(cnt) as max_consec_days
from (
select
user_id,
diff,
count(*) as cnt
from (
select
user_id,
date_sub(fdate, interval idx day) as diff
from temp
)x
group by 1,2
) y
group by 1
查看12道真题和解析
