/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

12 votes330 views4 answers
How to drop all tables in postgresql
SQL
1 vote272 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote282 views1 answer
Psql attribute cannot login
SQL
0 vote269 views1 answer
Install ms sql server management studio
SQL
3 votes261 views1 answer
Index using in query plsql
SQL
0 vote311 views1 answer
Pgadmin check database
SQL
0 vote298 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote286 views1 answer
Sql last time database was accessed
SQL
0 vote266 views1 answer
Mysql regex exact match
SQL
1 vote289 views1 answer
Regular expression in sql server
SQL