/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

0 vote415 views1 answer
Sql server synonym
SQL
0 vote374 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote385 views1 answer
C# mysql data reader from two tables
SQL
1 vote347 views3 answers
Mariadb add foreign key
SQL
0 vote344 views1 answer
Django mysqlclient connection string
SQL
0 vote359 views1 answer
How to connect postgresql database with java
SQL
0 vote381 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote401 views3 answers
Mysql keyword search
SQL
0 vote351 views1 answer
Excute raw query
SQL
0 vote354 views1 answer
Sql contains vs like
SQL