YYYYMMDDHHSS's recent timeline updates YYYYMMDDHHSS's recent timeline updates |
YYYYMMDDHHSSV2EX member #507309, joined on 2020-09-09 13:31:21 +08:00 |
| 是不是做的所有事都是把大象放进冰箱的三步？ 问与答 • YYYYMMDDHHSS • Mar 19, 2021 • Lastly replied by wzb0909 | 5 |
| 求， plsql developer 的好用的替代品 问与答 • YYYYMMDDHHSS • Jan 11, 2021 • Lastly replied by YYYYMMDDHHSS | 4 |
| 安卓机，一加 7，有些应用不允许截图，比如股票的风险解析界面，用别的应用可以吗？有法律风险吗？ 问与答 • YYYYMMDDHHSS • Jan 1, 2021 • Lastly replied by cooioobb | 3 |
| 退休 iPhone7 想内网穿透搞成服务器玩玩是否可行，需要学习哪些工具 问与答 • YYYYMMDDHHSS • Nov 19, 2020 • Lastly replied by shequ2046 | 3 |
| 自己注册公司给自己交社保这种想法可行吗？ 问与答 • YYYYMMDDHHSS • Nov 18, 2020 • Lastly replied by julyclyde | 4 |
| FreeOffice 好用吗？ 问与答 • YYYYMMDDHHSS • Oct 27, 2020 |
| [认真提问]仿别人的产品实现会遇到哪些法律问题？ 问与答 • YYYYMMDDHHSS • Oct 8, 2020 • Lastly replied by zhangdszq | 10 |
YYYYMMDDHHSS's recent replies
Mar 2, 2023 Replied to a topic by 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
----
大数据量不建议这样做
Feb 23, 2021 Replied to a topic by zhuzhibin › 生活 › [!]钥匙忘记带了,找人开锁,1 分钟结束 50 块没了 |
我这开锁 100，兄弟
Feb 22, 2021 Replied to a topic by Touchevent › 随想 › 谁来翻译翻译，什么他吗的叫惊喜？什么他吗的叫他吗的惊喜。。。 |
买个发胶自己修修
Feb 19, 2021 Replied to a topic by Touchevent › 问与答 › 开朗的性格需要什么来支撑？ |
快乐的童年
Feb 8, 2021 Replied to a topic by theqiang › 生活 › 双方父母不能支持买房的打工人该何去何从 |
@rylei 不过是望山跑死马
扎辫子不就得了
Jan 18, 2021 Replied to a topic by polyang › 程序员 › 在外包呆久了真的很可怕，感觉我快要废了 |
技术大神也是靠时间钻研的，讲道理对于大多数精力有限的人来说到底学习本身是不会带来快乐的，回报才能。
Jan 15, 2021 Replied to a topic by captain2011 › 职场话题 › 女生觉得国企工作太压抑了，想跳出来 |
如果是海外客服可是要上夜班的
Jan 13, 2021 Replied to a topic by WishMeLz › 程序员 › 请教一个问题，想搭建一个网站，目的就是一些人发一些文章用的 |
语雀
Select Language