题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select user_id
from (
select user_id,
date_sub(log_date, interval row_number() over (partition by user_id order by log_date) day) dt_sub
from (
select distinct user_id,
date_format(log_time,'%Y-%m-%d') log_date
from login_tb l
join register_tb r using (user_id)
) t1
) t2
group by user_id, dt_sub
having count(*)>=3
order by user_id
查看14道真题和解析
