YYYYMMDDHHSS 最近的时间轴更新 YYYYMMDDHHSS 最近的时间轴更新 | YYYYMMDDHHSSV2EX 第 507309 号会员，加入于 2020-09-09 13:31:21 +08:00 |
| 是不是做的所有事都是把大象放进冰箱的三步？ 问与答 YYYYMMDDHHSS 2021-03-19 14:46:22 PM 最后回复来自 wzb0909 | 5 |
| 求， plsql developer 的好用的替代品 问与答 YYYYMMDDHHSS 2021-01-11 11:14:05 AM 最后回复来自 YYYYMMDDHHSS | 4 |
| 安卓机，一加 7，有些应用不允许截图，比如股票的风险解析界面，用别的应用可以吗？有法律风险吗？ 问与答 YYYYMMDDHHSS 2021-01-01 11:25:05 AM 最后回复来自 cooioobb | 3 |
| 退休 iPhone7 想内网穿透搞成服务器玩玩是否可行，需要学习哪些工具 问与答 YYYYMMDDHHSS 2020-11-19 15:52:27 PM 最后回复来自 shequ2046 | 3 |
| 自己注册公司给自己交社保这种想法可行吗？ 问与答 YYYYMMDDHHSS 2020-11-18 15:30:47 PM 最后回复来自 julyclyde | 4 |
| FreeOffice 好用吗？ 问与答 YYYYMMDDHHSS 2020-10-27 16:25:22 PM |
| [认真提问]仿别人的产品实现会遇到哪些法律问题？ 问与答 YYYYMMDDHHSS 2020-10-08 00:43:17 AM 最后回复来自 zhangdszq | 10 |
YYYYMMDDHHSS 最近回复了
2023-03-02 17:40:33 +08:00 回复了 killva4624 创建的主题 MySQL 如何按天统计前 7 天周活？ |
with data as (
select '2023-01-01' as dt ,'UserA' as user_name union all
select '2023-01-01' as dt ,'UserB' as user_name union all
select '2023-01-02' as dt ,'UserA' as user_name union all
select '2023-01-03' as dt ,'UserC' as user_name union all
select '2023-01-04' as dt ,'UserA' as user_name union all
select '2023-01-05' as dt ,'UserB' as user_name union all
select '2023-01-06' as dt ,'UserA' as user_name union all
select '2023-01-07' as dt ,'UserC' as user_name union all
select '2023-01-09' as dt ,'UserA' as user_name union all
select '2023-01-10' as dt ,'UserB' as user_name union all
select '2023-01-11' as dt ,'UserA' as user_name union all
select '2023-01-12' as dt ,'UserC' as user_name union all
select '2023-01-13' as dt ,'UserA' as user_name union all
select '2023-01-14' as dt ,'UserB' as user_name union all
select '2023-01-15' as dt ,'UserA' as user_name union all
select '2023-01-16' as dt ,'UserC' as user_name union all
select '2023-01-17' as dt ,'UserA' as user_name union all
select '2023-01-18' as dt ,'UserB' as user_name
)
select
t.dt,
date_add(t.dt, 7) dt_to,
count(distinct t.user_name) as cnt
from
(
select
d1.dt,
d2.user_name
from
data d1
join data d2
where
1 = 1
--and d1.dt > d2.dt
and datediff(d1.dt, d2.dt) <= 7
) t
group by
dt
----
大数据量不建议这样做
select '2023-01-01' as dt ,'UserA' as user_name union all
select '2023-01-01' as dt ,'UserB' as user_name union all
select '2023-01-02' as dt ,'UserA' as user_name union all
select '2023-01-03' as dt ,'UserC' as user_name union all
select '2023-01-04' as dt ,'UserA' as user_name union all
select '2023-01-05' as dt ,'UserB' as user_name union all
select '2023-01-06' as dt ,'UserA' as user_name union all
select '2023-01-07' as dt ,'UserC' as user_name union all
select '2023-01-09' as dt ,'UserA' as user_name union all
select '2023-01-10' as dt ,'UserB' as user_name union all
select '2023-01-11' as dt ,'UserA' as user_name union all
select '2023-01-12' as dt ,'UserC' as user_name union all
select '2023-01-13' as dt ,'UserA' as user_name union all
select '2023-01-14' as dt ,'UserB' as user_name union all
select '2023-01-15' as dt ,'UserA' as user_name union all
select '2023-01-16' as dt ,'UserC' as user_name union all
select '2023-01-17' as dt ,'UserA' as user_name union all
select '2023-01-18' as dt ,'UserB' as user_name
)
select
t.dt,
date_add(t.dt, 7) dt_to,
count(distinct t.user_name) as cnt
from
(
select
d1.dt,
d2.user_name
from
data d1
join data d2
where
1 = 1
--and d1.dt > d2.dt
and datediff(d1.dt, d2.dt) <= 7
) t
group by
dt
----
大数据量不建议这样做
2021-02-23 08:44:50 +08:00 回复了 zhuzhibin 创建的主题 生活 [!]钥匙忘记带了,找人开锁,1 分钟结束 50 块没了 |
我这开锁 100，兄弟
2021-02-22 12:41:15 +08:00 回复了 Touchevent 创建的主题 随想 谁来翻译翻译，什么他吗的叫惊喜？什么他吗的叫他吗的惊喜。。。 |
买个发胶自己修修
2021-02-19 13:09:08 +08:00 回复了 Touchevent 创建的主题 问与答 开朗的性格需要什么来支撑？ |
快乐的童年
2021-02-08 11:29:11 +08:00 回复了 theqiang 创建的主题 生活 双方父母不能支持买房的打工人该何去何从 |
@rylei 不过是望山跑死马
扎辫子不就得了
2021-01-18 09:22:14 +08:00 回复了 polyang 创建的主题 程序员 在外包呆久了真的很可怕，感觉我快要废了 |
技术大神也是靠时间钻研的，讲道理对于大多数精力有限的人来说到底学习本身是不会带来快乐的，回报才能。
2021-01-15 11:26:33 +08:00 回复了 captain2011 创建的主题 职场话题 女生觉得国企工作太压抑了，想跳出来 |
如果是海外客服可是要上夜班的
2021-01-13 10:32:12 +08:00 回复了 WishMeLz 创建的主题 程序员 请教一个问题，想搭建一个网站，目的就是一些人发一些文章用的 |
语雀