/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 votes186 views1 answer
Sql select second max
SQL
0 vote112 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote146 views2 answers
Start mysql server using docker
SQL
1 vote155 views1 answer
Sql group by error
SQL
0 vote154 views1 answer
Xampp increame mysql speed
SQL
4 votes154 views1 answer
To date oracle with time
SQL
1 vote177 views1 answer
Get current date in pyspark sql
SQL
1 vote144 views1 answer
Foreign key constraint in ms sql
SQL
5 votes190 views1 answer
How to get all table names in sql query
SQL
15 votes139 views4 answers
T-sql drop function if exists
SQL