/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

5 votes368 views2 answers
Mysql dump mysql db cli
SQL
1 vote325 views1 answer
Query for all indexes in table postgres
SQL
0 vote365 views1 answer
How to use sqlcommand
SQL
0 vote334 views1 answer
Like date sql server not working
SQL
0 vote303 views1 answer
Sql compound operators
SQL
0 vote334 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote324 views1 answer
Restart sql server command line linux
SQL
0 vote315 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote324 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
1 vote302 views1 answer
How to delete record sql delphi
SQL