創建表：

CREATE TABLE `tb` (`時間` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',`小數` decimal(7,5) NOT NULL DEFAULT '0.00000' )

插入數據：

INSERT INTO `tb`(`時間`, `小數`) VALUES ('2022-05-30 00:00:01',0.07523), ('2022-05-30 00:01:00',0.04416), ('2022-05-30 00:02:01',0.04429), ('2022-05-30 00:03:00',0.04348), ('2022-05-30 00:04:01',0.02853), ('2022-05-30 00:05:01',0.01429), ('2022-05-30 00:06:01',0.01409), ('2022-05-30 00:07:01',0.01517), ('2022-05-30 00:08:01',0.04371), ('2022-05-30 00:09:01',0.06100), ('2022-05-30 00:10:01',0.08211), ('2022-05-30 00:11:01',0.08391), ('2022-05-30 00:12:01',0.13065), ('2022-05-30 00:13:01',0.17940), ('2022-05-30 00:14:01',0.21385)

如圖：

?使用如下SQL語句實現：

SELECT substr(MAX(時間),12,5) as 時間,AVG(小數) as 每組平均數 FROM `tb` group by floor(MINUTE( 時間 )/ 10 ) * 10

或者如下語句實現：

SELECT date_format(MAX(時間),'%H:%i') as 時間,AVG(小數) as 每組平均數 FROM `tb` group by floor(MINUTE( 時間 )/ 10 ) * 10

按每10分鐘分組最終結果如下：

?sqlserver語句實現可以用：
?

select CONVERT(varchar(5),max([時間 ]),8) as 時間 ,avg([小數]) as 每組平均數 from [tb] group by cast(floor(cast([時間] as float)*24*60/10)*10/60/24 as smalldatetime)

結果如下：

?

總結

以上是生活随笔為你收集整理的SQL按每5分钟或者10分钟分组统计数据的全部內容，希望文章能夠幫你解決所遇到的問題。

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