Horje
group by 15 minute interval sql server Code Example
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



Sql

Related
crontab every month Code Example crontab every month Code Example
oracle list next running jobs Code Example oracle list next running jobs Code Example
check mysql timezone Code Example check mysql timezone Code Example
how to see logical reads in sql server Code Example how to see logical reads in sql server Code Example
cannot return non-composite value from function that returns composite type Code Example cannot return non-composite value from function that returns composite type Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje