题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
with t1 as( select l.user_id,log_time, row_number() over(partition by user_id order by log_time) rn from login_tb l inner join register_tb r on l.user_id = r.user_id group by user_id,log_time ) select user_id from t1 group by user_id,date(date_sub(log_time,interval rn day)) having count(1) >2 order by user_id
查看2道真题和解析