获取某天每个小时的数据量,每分钟的数据量
获取 每个小时的处方量 :
select HOUR(create_time) as time,COUNT() 数量 from prescription where DATE(create_time)=‘2019-11-26’ GROUP BY time
获取每分钟的处方量:
select a.time1,COUNT() from (select pre_id,DATE_FORMAT(create_time,’%Y-%m-%d %H:%i’) as time1,create_time from prescription )as a GROUP BY a.time1