/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

10 votes283 views2 answers
Mysql select timestamp group by day
SQL
1 vote326 views1 answer
Avg mysql
SQL
0 vote292 views1 answer
Drop all tables in azure sql database
SQL
2 votes294 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote309 views2 answers
Sql trigger difference between for and after
SQL
2 votes355 views1 answer
Mysql select true or false
SQL
0 vote297 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote327 views2 answers
How to add CHECK constraint to a column in postgres
SQL
1 vote308 views1 answer
Oracle drop chain step
SQL
0 vote289 views1 answer
Soql more than today
SQL