摘要: 1、连续3天登录的用户 select user_id ,count(1) as `连续登录天数` ,min(login_date) as `开始日期` ,max(login_date) as `结束日期` from ( select user_id ,login_date ,rn ,date_sub 阅读全文
posted @ 2025-06-30 11:14 苏su 阅读(10) 评论(0) 推荐(0)