sql月，年，统计报表sql报表

select
      DevName as 设备名称, 
      count(flux) as 流量数据个数,  
      max(flux) as 流量最大值,  
      min(flux) as 流量最小值, 
      avg(flux) as 流量平均值, 
      count(Flux_AV)  as 流速数据个数,  
      max(Flux_AV) as 流速最大值,  
      min(Flux_AV) as 流速最小值,  
      avg(Flux_AV) as 流速平均值  
from realtime  
where
     year(savetime)='2013'
     and month(savetime)='5'
GROUP BY DevName, 
      datepart(yy,savetime), 
      datepart(mm,savetime)