/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 vote171 views1 answer
Show create table in postgresql
SQL
0 vote261 views1 answer
Example database query
SQL
0 vote133 views1 answer
Print sum of values sql
SQL
3 votes182 views2 answers
Tsql join multiple record in one string
SQL
0 vote247 views1 answer
SQL check if record exist
SQL
1 vote171 views1 answer
DATE_SUB postgres
SQL
0 vote196 views1 answer
Remove mysql from centos 7
SQL
0 vote178 views1 answer
T sql check active deadlock
SQL
0 vote259 views1 answer
Do you know sql
SQL
0 vote169 views1 answer
Mysql set column equal to another automatic
SQL