题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
select user_id, MAX(max_consec_days) as max_consec_days from (SELECT
user_id,
DAY(fdate) - row_num AS ceshi,
count(*) as max_consec_days
FROM (
SELECT
user_id,
fdate,
ROW_NUMBER() OVER(PARTITION BY user_id ORDER BY fdate) AS row_num
FROM tb_dau
) AS subquery
group by user_id ,ceshi
) as end1
GROUP BY user_id;