set @gourpmi = 5
select cast(floor(cast(时间 as float)2460/gourpmi)gourpmi/60/24 as smalldatetime),SUM(字段),Count(字段)from tbgroup by cast(floor(cast(时间 as float)2460/gourpmi)gourpmi/60/24 as smalldatetime)
SQL 按分钟分组
原文：https://blog.51cto.com/alun51cto/2483830
