Breaking News: Grepper is joining You.com. Read the official announcement!

group by 15 minute interval sql server

Sven Snusberg answered on September 21, 2021 Popularity 7/10 Helpfulness 6/10

answer group by 15 minute interval sql server

group by 15 minute interval sql server

Comment

SELECT   DATEADD(MINUTE, DATEDIFF(MINUTE, '2000', aa.[date]) / 10 * 10, '2000')
                                                             AS [date_truncated],
         COUNT(*) AS [records_in_interval],
         AVG(aa.[value]) AS [average_value]
FROM     [friib].[dbo].[archive_analog] AS aa
-- WHERE aa.[date] > '1900-01-01'
GROUP BY DATEADD(MINUTE, DATEDIFF(MINUTE, '2000', aa.[date]) / 10 * 10, '2000')
ORDER BY [date_truncated]

Popularity 7/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: group-by minute sql sql-server

Link to this answer
Share Copy Link