题解 | #最长连续登录天数#
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
with tiaojian as ( select user_id, count(user_id) as cnt from( select fdate, user_id, row_number()over(partition by user_id order by fdate) as pn from tb_dau ) as t group by user_id,subdate(fdate,pn) ) select user_id, max(cnt) as max_consec_days from tiaojian group by user_id
查看17道真题和解析