/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 vote201 views1 answer
R write csv without index
SQL
1 vote191 views1 answer
Sql delete all values in a column
SQL
3 votes231 views1 answer
Unsigned int in mysql
SQL
1 vote197 views1 answer
Spark sql concatenate string and int
SQL
0 vote213 views1 answer
Second Step in installing SQL workbench
SQL
3 votes182 views3 answers
Concatenation in sql
SQL
0 vote191 views1 answer
Sql server query database space available
SQL
0 vote187 views1 answer
Suse status MySQL
SQL
16 votes187 views3 answers
Delete row psql
SQL
0 vote232 views10 answers
Sql statement checker corrector
SQL