- select
- DATE_FORMAT(server_time,'%H:%i') ,(sum(flow_value)-max(flow_value)-min(flow_value))/7
- from
- table_name
- where
- server_time >= 'date9 00:00:00' and server_time <= 'date1 23:59:59'
- group by DATE_FORMAT(server_time,'%H:%i')
- order by DATE_FORMAT(server_time,'%H:%i');
- 其中
- table_name:查询的表
- date9:从昨天往前数九天的yyyy-mm-dd形式
- date1:昨天的yyyy-mm-dd形式
来源: http://www.phpxs.com/code/1005291/