/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

5 votes143 views1 answer
Sysdate in oracle sql
SQL
0 vote152 views1 answer
Sql delete dastabase
SQL
2 votes166 views2 answers
Mysql write into table
SQL
16 votes141 views6 answers
Mysql find and replace
SQL
7 votes147 views1 answer
Connect mysql docker
SQL
11 votes139 views4 answers
MYSQL LOGIN
SQL
1 vote164 views1 answer
Oracle compile schema
SQL
0 vote169 views1 answer
Sql developer sql worksheet not showing
SQL
-1 vote140 views1 answer
Mac mysql workbench console
SQL
4 votes167 views2 answers
Dbms output
SQL