/SQL/Group by 15 minute interval sql server

Group by 15 minute interval sql server

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]

Source: stackoverflow.com

Similar codes

28 votes313 views6 answers
Foreign key
SQL
1 vote306 views3 answers
How to filter repeated same result using sql query
SQL
1 vote302 views1 answer
Oracle grant select on schema
SQL
31 votes297 views3 answers
SQL Server change column data type
SQL
-1 vote284 views1 answer
MYSQL stored procedure select from
SQL
0 vote285 views1 answer
Mysql money value
SQL
6 votes314 views2 answers
Difference between join vs union
SQL
1 vote286 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote288 views2 answers
How to type a blank discord messgae
SQL
0 vote278 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL