/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

-1 vote194 views1 answer
Ssql to lowercqse
SQL
7 votes186 views3 answers
Python and mysql connectivity
SQL
0 vote179 views1 answer
How to put is null in where in clause
SQL
3 votes190 views1 answer
Postgres add not null to existing column
SQL
0 vote180 views1 answer
Get who is hired in month in sql
SQL
0 vote185 views4 answers
Stored procedure sql
SQL
0 vote241 views1 answer
Sql server query all database objects
SQL
0 vote184 views2 answers
Postgresql get last day of month
SQL
3 votes184 views2 answers
Oracle apex charging debug
SQL
3 votes162 views3 answers
Docker create postgresql database
SQL