最长连续登录天数

昨夜花落尽

已于 2024-12-06 14:22:34 修改

阅读量137

点赞数 1

分类专栏： sql练习题文章标签：数据库

于 2024-12-05 17:20:48 首次发布

本文链接：https://blog.csdn.net/weixin_43918196/article/details/144271820

版权

sql练习题专栏收录该内容

5 篇文章

订阅专栏

在这里插入图片描述

select user_id,max(count1) as max_consec_days
from
(select user_id,
       count(diff) as count1
from
(select user_id,
       fdate,
       date_sub(fdate,interval rk day) as diff
from
(select user_id,
       fdate,
       row_number() over(partition by user_id order by fdate) as rk
from 
(select  distinct fdate,user_id
from tb_dau)t1)t2)t3
group by user_id,diff)t4
group by user_id