表中每隔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])

總結

以上是生活随笔為你收集整理的sqk，按分钟统计平均值的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。