/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 vote127 views1 answer
Compare subqueries oracle
SQL
0 vote130 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote125 views1 answer
Mariadb current date plus 1 day
SQL
0 vote114 views1 answer
Name '_mysql' is not defined
SQL
0 vote133 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes109 views2 answers
Get all columns from table sql
SQL
9 votes124 views3 answers
Sql delete where in
SQL
59 votes299 views6 answers
Alter table sql
SQL
1 vote126 views1 answer
Psql connections
SQL
0 vote126 views1 answer
Oracle sql copy table without data
SQL