sqk，按分钟统计平均值

表中每隔10秒左右记录一条数据，sql统计每分钟的平均值

SELECT 

     AVG(CONVERT(float, [Value],10)) as value
      ,datepart(MINUTE,[TimeStamp]) as m,datepart(hour,[TimeStamp]) as h,DAY([TimeStamp])as d
  FROM [YKEAI].[dbo].[History]
  where TagKey='YK03110001101'
  and( [TimeStamp] between '2014-3-21 00:00:01' and '2014-3-22 23:59:59')
  group by DAY([TimeStamp]),datepart(hour,[TimeStamp]), datepart(MINUTE,[TimeStamp])
 order by DAY([TimeStamp]), datepart(hour,[TimeStamp]),datepart(MINUTE,[TimeStamp])