2021-12-22 09:59
中国石油大学(华东) 数据分析师 Sophia!:请问t1.dt=date_sub(t2.dt,INTERVAL 1 day)前面为什么要用and连接,而不用where呢?
0 点赞 评论 收藏
分享
2021-12-08 18:00
中国石油大学(华东) 数据分析师 0 点赞 评论 收藏
分享
2021-12-08 17:57
中国石油大学(华东) 数据分析师 粒牛牛:select * from (select tag,date(start_time)dt, sum(sum(if_like)) over(PARTITION BY tag ORDER BY date(start_time) DESC ROWS BETWEEN CURRENT ROW AND 6 FOLLOWING) sum_like_cnt_7d, max(sum(if_retweet)) over(partition by tag order by date(start_time) desc rows between current row and 6 following) max_retweet_cnt_7d from tb_user_video_log left join tb_video_info using(video_id) group by tag,date(start_time) order by date(start_time) desc)a where dt between "2021-10-01" and "2021-10-03" order by tag desc,dt;
0 点赞 评论 收藏
分享
创作者周榜
更多
关注他的用户也关注了: