/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

-1 vote225 views1 answer
Mysql delete duplicate rows except one
SQL
2 votes228 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote228 views1 answer
Executescalar in sql server
SQL
1 vote208 views1 answer
How to get the date diff on once field in sql server
SQL
20 votes220 views6 answers
Creating a table in sql
SQL
0 vote203 views1 answer
How many columns can be used for creating index?
SQL
1 vote221 views4 answers
Get week day from date in sql
SQL
1 vote199 views2 answers
Find a column in all tables mysql
SQL
0 vote193 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote239 views1 answer
Ubuntu stop mysql from starting on boot
SQL