/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

1 vote280 views1 answer
Sqlalchemy order by descending
SQL
0 vote289 views1 answer
Oracle winter time change
SQL
21 votes264 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote260 views1 answer
Join in update query in mysql
SQL
7 votes290 views1 answer
Oracle alter sequence restart start with
SQL
1 vote276 views1 answer
How to delete data from sql database in android
SQL
0 vote280 views2 answers
Homebrew nysql launch
SQL
0 vote273 views1 answer
Mysql wait_timeout
SQL
0 vote263 views2 answers
Auto increment column in mysql query results
SQL
6 votes315 views3 answers
Check if string contains substring sql
SQL