小田是我

分类

/ 注册

全部文章（共3篇）

题解 | #每个创作者每月的涨粉率及截止当前的总粉丝量#

#不用窗口函数的解法 select t1.author,t1.month,t1.fans_growth_rate,sum(fans_cnt) as total_fans from (select author,date_format(start_time,'%Y-%m') as month ,rou...

2024-09-06

0 86

题解 | #查询连续登陆的用户#

select a.user_id from login_tb as a inner join login_tb as b on a.user_id = b.user_id and date(a.log_time)=date(b.log_time)-1 #自联结，条件是某一用户存在第二天的登录记录...

2024-09-05

0 105

题解 | #查询连续登陆的用户#

select a.user_id from login_tb as a inner join login_tb as b on a.user_id = b.user_id and date(a.log_time)=date(b.log_time)-1 #自联结，条件是某一用户存在第二天的登录记录...

2024-09-05

19 193