数据准备
CREATE TABLE `user_login` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`login_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
#插入数据
INSERT INTO study.user_login (user_id,login_date) VALUES
(100,'2023-10-01 00:00:00.0')
,(100,'2023-10-02 00:00:00.0')
,(100,'2023-10-03 00:00:00.0')
,(100,'2023-10-04 00:00:00.0')
,(100,'2023-10-05 00:00:00.0')
,(100,'2023-10-06 00:00:00.0')
,(100,'2023-10-07 00:00:00.0')
,(100,'2023-10-07 00:00:00.0')
,(200,'2023-10-20 00:00:00.0')
,(200,'2023-10-22 00:00:00.0')
;
INSERT INTO study.user_login (user_id,login_date) VALUES
(200,'2023-10-23 00:00:00.0')
;
SQL
select
log_date,
user_id from
(
select
*,
date_sub(log_date,interval rank_num day) real_date
from
(
select
*,
row_number() over (partition by user_id order by log_date ) as rank_num
from
(
select
distinct date(login_date) as log_date ,user_id
from study.user_login
) a
) b
) c
group by real_date, user_id HAVING COUNT(*) >=7
请自行观察结果
文章来源地址https://www.toymoban.com/news/detail-801720.html
文章来源：https://www.toymoban.com/news/detail-801720.html
到了这里，关于SQL-01求连续七天登陆的用户的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
![问题解决：idea 中无法连接 sql server 数据库，报错 [08S01] 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接](https://imgs.yssmx.com/Uploads/2024/02/526720-1.png)
