/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

3 votes324 views1 answer
Make a field auto_increment mysql
SQL
0 vote323 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote318 views1 answer
Including parameters in OPENQUERY
SQL
0 vote329 views1 answer
Mysql concat and use as where column
SQL
1 vote372 views1 answer
Isnull sql server
SQL
0 vote333 views1 answer
Ignore case in string sql
SQL
0 vote342 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote328 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
2 votes337 views4 answers
Duplicate record mysql
SQL
1 vote355 views1 answer
Sql check roles
SQL