/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 vote131 views1 answer
Codeigniter 3 get best-selling products
SQL
44 votes208 views6 answers
Rename command in sql
SQL
0 vote124 views1 answer
Postgresql add not null and not empty constraint
SQL
5 votes141 views2 answers
Oracle show procedures
SQL
0 vote127 views1 answer
Sql case when exists in another table
SQL
1 vote186 views2 answers
Truncate table sqlite
SQL
4 votes145 views3 answers
Is not null sql
SQL
0 vote132 views1 answer
Gcloud check sql
SQL
0 vote150 views1 answer
Excel vba import data to sql server
SQL
5 votes134 views3 answers
Sql make column nullable
SQL