/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

104 votes446 views2 answers
Like in mysql
SQL
1 vote266 views1 answer
Mysql view command
SQL
0 vote291 views1 answer
Get initials name in sql
SQL
0 vote268 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote287 views1 answer
Sql sum if
SQL
0 vote311 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
4 votes279 views3 answers
Rename table column postgresql
SQL
0 vote268 views1 answer
Add colum date in sql
SQL
0 vote289 views1 answer
Sql filter rows with condition
SQL
0 vote263 views1 answer
Postgres full text search example
SQL