题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select t1.l_user from(
select
l.user_id as l_user, r.user_id as r_user,
row_number()over(partition by l.user_id order by date(l.log_time)) as rn
from
login_tb l left join register_tb r
on
l.user_id = r.user_id
where
l.user_id = r.user_id
)t1
where
t1.rn >= 3
查看2道真题和解析