/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 vote357 views2 answers
Get top 1 row of each group
SQL
1 vote390 views1 answer
Psql filed name alter
SQL
3 votes358 views2 answers
Oracle apex charging debug
SQL
2 votes362 views2 answers
Mysql limit
SQL
0 vote375 views1 answer
Procedure excute monthly oracle
SQL
0 vote348 views1 answer
Duplicate value unique constraint mysql error
SQL
14 votes371 views1 answer
Oracle alter table add column not null
SQL
0 vote366 views1 answer
Sql script get all stored procedures from database
SQL
0 vote347 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote353 views1 answer
How to print mysql query of codeigniter query builder
SQL