mysql 怎么统计七天内的订单，和每日的订单啊？-灵析社区

七天内的订单: SELECT * FROM t_order WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(create_time); 七天内每天的订单数量,先用where条件查出七天内的订单,再用group by 对每天进行分组就行了: SELECT DATE(create_time) createtime,COUNT(*) FROM t_order WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(create_time) GROUP BY createtime;