/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

2 votes201 views1 answer
How to make insert script from table in SQL server
SQL
0 vote211 views1 answer
Mysqli last row
SQL
3 votes185 views2 answers
Oracle for loop
SQL
0 vote186 views4 answers
Sql limit 1 offset 1
SQL
12 votes203 views4 answers
Import mysql database command line linux
SQL
1 vote203 views1 answer
Oracle apex run 404
SQL
0 vote214 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote243 views1 answer
Modifier une valeur sql
SQL
23 votes224 views4 answers
How to show all users in mysql
SQL
1 vote239 views1 answer
Backup mysql schema only
SQL