1、查询连续登录天数
题:数据表metaInfo中包含uid,event_day字段,现要查找用户的最大连续登录天数
select
uid,
max(continue_day) as login_day
from (
select
uid,
date_sub(event_day, rank) as df,
count(1) as continue_day,
from (
select
uid,
event_day,
row_number() over(partition by uid order by event_day) rank
from metaInfo
) t1
group by uid,date_sub(event_day, rank)
) t2
group by uid
博主真是太厉害了!!!
不错不错,我喜欢看 https://www.jiwenlaw.com/
看的我热血沸腾啊https://www.237fa.com/
想想你的文章写的特别好https://www.ea55.com/
想想你的文章写的特别好www.jiwenlaw.com
《非故意恋爱故事》韩国剧高清在线免费观看:https://www.jgz518.com/xingkong/57010.html
《地狱少女》恐怖片高清在线免费观看:https://www.jgz518.com/xingkong/10582.html
《欲劫迷离》剧情片高清在线免费观看:https://www.jgz518.com/xingkong/37192.html
《小戏骨:黄飞鸿》剧情片高清在线免费观看:https://www.jgz518.com/xingkong/22062.html
《浪荡儿1953》喜剧片高清在线免费观看:https://www.jgz518.com/xingkong/120658.html
《追踪者游戏W2》日本剧高清在线免费观看:https://www.jgz518.com/xingkong/138077.html