MySql sql按时间分组

最新推荐文章于 2023-04-21 17:40:14 发布

weixin_34396902

最新推荐文章于 2023-04-21 17:40:14 发布

阅读量124

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/start-fxw/p/5909445.html

版权

select   DATE_FORMAT(f.upload_time,'%Y%u') weeks,count(*),sum(p.download_times),sum(p.collection_times),sum(p.click_times)    from file_base f left join file_property p on f.property_id = p.id   group by weeks;

select   DATE_FORMAT(f.upload_time,'%Y-%m-%d') days,count(*),sum(p.download_times),sum(p.collection_times),sum(p.click_times)
	from file_base f left join file_property p on f.property_id = p.id  group by days;

select   DATE_FORMAT(f.upload_time,'%Y%m') months,count(*),sum(p.download_times),sum(p.collection_times),sum(p.click_times) from file_base f left join file_property p on f.property_id = p.id   group by months;

转载于:https://www.cnblogs.com/start-fxw/p/5909445.html