/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 vote137 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote191 views1 answer
Get statis values sql
SQL
0 vote188 views1 answer
Sql alchemy escape ; in insert statement
SQL
2 votes146 views1 answer
Oracle sql merge
SQL
11 votes130 views1 answer
Mysql order by two columns priority
SQL
0 vote138 views1 answer
Cannot pip install mysqlclient
SQL
0 vote129 views1 answer
Mysql start of today
SQL
0 vote139 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote170 views1 answer
Mysql select random rows large table
SQL
0 vote133 views2 answers
Select columns from 2 tables with foreign key
SQL