/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 vote200 views1 answer
Html css mobile menu arrow dropdown
SQL
12 votes242 views4 answers
How to check mysql version ubuntu
SQL
-1 vote216 views1 answer
Mysql extract days
SQL
10 votes218 views1 answer
Oracle object dependencies
SQL
0 vote206 views1 answer
On update current_timestamp jpa
SQL
1 vote210 views2 answers
End mysql command
SQL
2 votes221 views1 answer
Sql missing records from another table
SQL
0 vote219 views2 answers
How to relationship query two different tables in MySQL
SQL
4 votes210 views1 answer
Wilayah indonesia sql
SQL
0 vote218 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL