题解 | #查询连续登陆的用户#
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select user_id
from
(
select user_id
, count(date_sub(date_1,interval rn day)) num
from
(
select a.user_id
, date(log_time) date_1
, row_number()over(partition by user_id order by date(log_time)) rn
from register_tb a left join login_tb b using(user_id)
) t1
group by user_id
) t2
where num>=3
查看5道真题和解析
投递阿里云等公司10个岗位