/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 vote329 views1 answer
Show indices in mysql table
SQL
0 vote317 views1 answer
SQL Error 1040 : Too many connections
SQL
-1 vote358 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote339 views1 answer
Sql not equal multiple columns
SQL
-1 vote357 views1 answer
Minus vs except in sql
SQL
1 vote354 views1 answer
Sql string function update replace
SQL
0 vote324 views1 answer
Sqlalchemy get ids
SQL
0 vote324 views1 answer
Use where instead of join
SQL
0 vote322 views1 answer
Mysql shell set time_zone
SQL
0 vote336 views1 answer
Oracle archivelog usage
SQL