/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

3 votes196 views1 answer
Select sequence oracle
SQL
0 vote192 views1 answer
Flexible search query delete table
SQL
11 votes175 views1 answer
Mysql order by two columns priority
SQL
20 votes194 views3 answers
How to open postgresql in mac
SQL
0 vote198 views1 answer
Sql server size of every table in a db
SQL
3 votes143 views4 answers
Mysql delete duplicate rows
SQL
0 vote213 views1 answer
Reset postgres table index to next max value
SQL
0 vote191 views1 answer
Reona
SQL
0 vote182 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
2 votes195 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL