/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 vote313 views2 answers
Datetrunc hour snowflake
SQL
0 vote282 views1 answer
Oracle list all stored procedures
SQL
0 vote307 views1 answer
Output to file mysql
SQL
0 vote301 views1 answer
Select only one row sql
SQL
9 votes326 views2 answers
Sql limit to 5 results
SQL
0 vote276 views1 answer
Java spring boot connect to sql server
SQL
0 vote302 views1 answer
Mysql begin statement
SQL
0 vote305 views1 answer
Mysql remove tabs from string
SQL
0 vote318 views1 answer
Mysql count unique in group statement
SQL
0 vote332 views1 answer
Display all node label neo4j
SQL