/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 vote254 views1 answer
How to find sql server name
SQL
3 votes257 views1 answer
Créer une table sql
SQL
0 vote256 views1 answer
Product of a column in mysql
SQL
0 vote244 views1 answer
Show all mongodb
SQL
6 votes277 views1 answer
Oracle pl sql source
SQL
0 vote241 views1 answer
Postgresql subquery
SQL
0 vote270 views1 answer
Repeatable read trong sql server
SQL
1 vote261 views1 answer
Sql server datetime vs datetime2
SQL
2 votes246 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote266 views3 answers
Get all tables postgres
SQL