/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

18 votes143 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
-1 vote146 views3 answers
Psql get last rows
SQL
0 vote153 views1 answer
How to open mysql in docker
SQL
1 vote130 views1 answer
Error code 1055
SQL
6 votes132 views1 answer
Oracle trigger after connect
SQL
1 vote140 views1 answer
Drop function
SQL
5 votes150 views2 answers
Oracle rename table
SQL
2 votes99 views1 answer
Sql select min value from multiple columns
SQL
2 votes137 views1 answer
How to delete view in sql
SQL
0 vote183 views1 answer
Oracle plsql sleep
SQL