Mysql语句查询统计一天中每个小时数据的数量统计

mysql语句统计每个小时的订单总数

sql语句

Mysql 查询一天中每半小时记录的数量

sql语句

SELECT HOUR( e.create_time ) AS HOUR,count( * ) AS Count FROMsale_order e WHEREe.create_time between '-09-26' and '-09-27' GROUP BYHOUR ( e.create_time ) ORDER BYHOUR ( e.create_time );

1234567891011

结果：

每个小时内卖出的订单总数

Mysql 查询一天中每半小时记录的数量

SELECT HOUR(e.time)as Hour,FLOOR(MINUTE(e.time)/30) as M, COUNT(*) as Count FROM error_log e WHERE e.date = '-09-02' GROUP BY FLOOR(MINUTE(e.time)/30),HOUR(e.time) ORDER BY Hour(e.time);

1

floor函数是mysql 的向下取整函数 如 floor(1.2) = 1

正在上传…重新上传取消weixin_460883