查询数据，没有数据补0，日期必须出现，一般用作图表数据查询

最新推荐文章于 2022-11-12 20:50:50 发布

吃范范

最新推荐文章于 2022-11-12 20:50:50 发布

阅读量336

点赞数

本文链接：https://blog.csdn.net/fanhuiixa/article/details/106090010

版权

SELECT IFNULL(b.count,0) AS `order` FROM ( SELECT DATE_SUB(CURDATE(), INTERVAL 6

DAY) AS click_date UNION ALL SELECT DATE_SUB(CURDATE(), INTERVAL 5 DAY) AS click_date UNION ALL SELECT DATE_SUB(CURDATE(), INTERVAL 4 DAY) AS click_date UNION ALL SELECT DATE_SUB(CURDATE(), INTERVAL 3 DAY) AS click_date UNION ALL SELECT DATE_SUB(CURDATE(), INTERVAL 2 DAY) AS click_date UNION ALL SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY) AS click_date UNION ALL SELECT CURDATE() AS click_date ) a LEFT JOIN ( SELECT DATE(e.`payTime`) AS `datetime`, COUNT(*) AS COUNT FROM `edu_eduorder` e LEFT JOIN `edu_course` ec ON e.`cid`= ec.`tid` WHERE e.`status`=2 AND ec.`instituId`=#{instituId} GROUP BY DATE(e.`payTime`) DESC ) b ON a.click_date = b.datetime