/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

11 votes201 views3 answers
Python sqlite3 create table if not exists
SQL
20 votes201 views3 answers
How to open postgresql in mac
SQL
0 vote181 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote222 views1 answer
Repeatable read trong sql server
SQL
0 vote191 views1 answer
Raiserror nowait sql server
SQL
-1 vote230 views1 answer
Create view in mysql workbench
SQL
5 votes269 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote159 views1 answer
Import in mysql without a software
SQL
4 votes283 views2 answers
Mysql alter table set column unique
SQL
0 vote195 views1 answer
Sql quary intervewi question
SQL