查询本周时间内的数据，并按每天分组

最新推荐文章于 2019-12-31 17:14:52 发布

PHP-0x590x610x6E0x67

最新推荐文章于 2019-12-31 17:14:52 发布

阅读量843

点赞数

分类专栏：技术小例子

本文链接：https://blog.csdn.net/qq_27367825/article/details/97933149

版权

技术小例子专栏收录该内容

14 篇文章 0 订阅

订阅专栏

代码如下：

select a.click_date,b.count
from (
select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 5 DAY) as click_date
       UNION ALL
       select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 4 DAY) as click_date
       UNION ALL
       select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 3 DAY) as click_date
       UNION ALL
       select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 2 DAY) as click_date
       UNION ALL
       select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 1 DAY) as click_date
       UNION ALL
       select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) DAY) as click_date
       UNION ALL
       select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 1 DAY) as click_date
) a left join (
select date(endtime) as datetime, SUM(money) as count
from table
group by date(endtime)
) b on a.click_date = b.datetime;