题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select user_id from (select user_id,log_time ,log_port,row_number() over(order by user_id)-ROW_NUMBER() over(partition by user_id order by log_time) as test from login_tb ) as flag where user_id in (select user_id from register_tb ) group by user_id having count(*)>=3