mysql语句统计每个小时的订单总数
sql语句
Mysql 查询一天中每半小时记录的数量
sql语句
SELECT HOUR
( e.create_time ) AS HOUR,
count( * ) AS Count
FROM
sale_order e
WHERE
e.create_time between '2018-09-26' and '2018-09-27'
GROUP BY
HOUR ( e.create_time )
ORDER BY
HOUR ( e.create_time );
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
结果:
每个小时内卖出的订单总数
Mysql 查询一天中每半小时记录的数量
SELECT HOUR(e.time)as Hour,FLOOR(MINUTE(e.time)/30) as M, COUNT(*) as Count FROM error_log e WHERE e.date = '2017-09-02' GROUP BY FLOOR(MINUTE(e.time)/30),HOUR(e.time) ORDER BY Hour(e.time);
- 1
floor函数是mysql 的向下取整函数 如 floor(1.2) = 1