题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select user_id
from (
select user_id,diff
from(
select subdate(day(log_time) ,row_number () over (partition by user_id order by day(log_time))) as diff,user_id
from login_tb
where user_id in (
select distinct user_id
from register_tb
)
) a
group by user_id ,diff
having count(*)>=3
) b
order by user_id
投递腾讯云智研发等公司7个岗位