题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select
user_id
from(
select
distinct user_id,
date(log_time), #登录时间
date(log_time)-row_number()over(partition by user_id order by date(log_time)) as date_sub
from register_tb
left join login_tb using(user_id)
order by user_id,date(log_time)asc
) as a
group by user_id
having(count(date_sub))>=3
查看7道真题和解析