create table active AS
SELECT 100 UID,
'2021-04-01' dt
UNION ALL
SELECT 101 UID,
'2021-04-01' dt
UNION ALL
SELECT 102 UID,
'2021-04-01' dt
UNION ALL
SELECT 103 UID,
'2021-04-01' dt
UNION ALL
SELECT 100 UID,
'2021-04-02' dt
UNION ALL
SELECT 101 UID,
'2021-04-02' dt
UNION ALL
SELECT 102 UID,
'2021-04-02' dt
UNION ALL
SELECT 103 UID,
'2021-04-02' dt
UNION ALL
SELECT 104 UID,
'2021-04-02' dt
UNION ALL
SELECT 100 UID,
'2021-04-03' dt
UNION ALL
SELECT 104 UID,
'2021-04-03' dt
UNION ALL
SELECT 101 UID,
'2021-04-04' dt
UNION ALL
SELECT 102 UID,
'2021-04-04' dt
UNION ALL
SELECT 103 UID,
'2021-04-04' dt
UNION ALL
SELECT 104 U
最大连续登录天数
最新推荐文章于 2024-08-01 08:23:29 发布
本文介绍如何使用SQL查询来计算用户在数据库记录中的最大连续登录天数,探讨了日期处理和序列分析在数据库查询中的应用,帮助读者理解如何从历史登录数据中提取连续登录信息。
摘要由CSDN通过智能技术生成