/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 vote169 views1 answer
List index mysql cli
SQL
35 votes194 views5 answers
Sql alter column
SQL
0 vote165 views1 answer
Postgres drop type
SQL
0 vote320 views1 answer
Hue hive UploadingTextFiletoHive
SQL
1 vote200 views3 answers
How to update column name in psql
SQL
0 vote191 views1 answer
Oracle execute package dblink
SQL
-1 vote159 views1 answer
Mysql case when multiple conditions
SQL
0 vote164 views1 answer
How should I pass a table name into a stored proc?
SQL
12 votes171 views1 answer
Docker run mysql image
SQL
0 vote183 views1 answer
T-SQL - Where Used List (Table/View)
SQL