FBLMG
8/15/2018 - 8:13 AM
数据库根据某一天24小时分组查询
数据库根据某一天24小时分组查询
select count(*), substring(scanning_time,12,2) from warning_results where scanning_time between '2017-08-10 00:00:00' and '2017-08-10 23:59:59' group by substring(scanning_time,12,2);数据库根据某一天24小时分组查询
select count(*), substring(scanning_time,12,2) from warning_results where scanning_time between '2017-08-10 00:00:00' and '2017-08-10 23:59:59' group by substring(scanning_time,12,2);