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

select user_id
from(
select l.user_id,date_format(DATE_SUB(log_time,interval row_number()over(partition by l.user_id order by date_format(log_time,'%Y-%m-%d')) day),'%Y-%m-%d') new_date 
from login_tb l join register_tb r on l.user_id=r.user_id
) t 
group by user_id,new_date
having count(*)>=3

注意日期转化为‘年-月-日’聚合计算方可有效。