/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 vote115 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote118 views1 answer
Postgres format date in select
SQL
5 votes126 views2 answers
Postgresql insert select
SQL
0 vote135 views1 answer
T-sql delete view if exists
SQL
8 votes111 views3 answers
Alter user root mysql
SQL
0 vote117 views1 answer
Setval postgres example table id
SQL
22 votes123 views3 answers
How to join three tables in sql using joins
SQL
4 votes110 views1 answer
Data types in sql
SQL
2 votes129 views2 answers
Mysql find max value row
SQL
0 vote113 views1 answer
Mysql group by derived column
SQL