题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
select p.user_id, max(consec_days) as max_consec_days
from(
select t.user_id, count(t.fdate - t.rn) as consec_days
from (
select fdate, user_id,
row_number() over (partition by user_id order by fdate asc) as rn
from tb_dau
) t
group by user_id, t.fdate - t.rn
) p
group by user_id
order by user_id asc
上海得物信息集团有限公司公司福利 1251人发布
查看15道真题和解析
