SELECT T.t,count(t) as '数量' FROM (SELECT *,HOUR(data_time) as t FROM `order_info` WHERE `data_time`>'2021-08-06 0:0:0') T GROUP BY T.t
mysql统计今天每小时的订单数量
最新推荐文章于 2023-07-06 12:03:14 发布
SELECT T.t,count(t) as '数量' FROM (SELECT *,HOUR(data_time) as t FROM `order_info` WHERE `data_time`>'2021-08-06 0:0:0') T GROUP BY T.t