题解 | #查询连续登陆的用户#

select user_id 
from register_tb
where user_id in 
(select tb1.user_id 
from login_tb as tb1
join (select user_id,log_time from login_tb) as tb2 on tb1.user_id = tb2.user_id
and datediff(tb2.log_time,tb1.log_time) = 1
join (select user_id,log_time from login_tb) as tb3 on tb2.user_id = tb3.user_id
and datediff(tb3.log_time,tb2.log_time) = 1 
)
order by user_id

分解问题，这是一道有关次日留存率问题。用子查询的方式