/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

2 votes223 views1 answer
Postgresql transaction
SQL
7 votes196 views1 answer
Return insert results in POSTGRESQL
SQL
6 votes185 views2 answers
Where clause in sql
SQL
1 vote173 views1 answer
Xampp import sql file command line
SQL
0 vote184 views1 answer
Mysql set variable to today's date
SQL
22 votes172 views3 answers
Join three tables sql
SQL
0 vote204 views3 answers
Join
SQL
0 vote192 views1 answer
Sqlite3 update select
SQL
0 vote224 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote189 views1 answer
Oracle nvl2
SQL