hi every one
i need a sql query that can sum count column between 2 hours
it's coming like this
date-time | counter | doors | center
2008-12-15 00:05:04 | 1 | 1 | ---
2008-12-15 00:12:32 | 2 | 1 | ---
2008-12-15 00:25:44 | 1 | 1 | ---
2008-12-15 00:32:11 | 1 | 1 | ---
2008-12-15 00:44:16 | 1 | 1 | ---
but i want to gather the table in one group
date-time | counter | doors | center
2008-12-15 01:00 | 50 | 1 | ---
i had been triad this one
SELECT [Date-Time] ,sum([counter]) ,[doors] , [center] FROM [counter_table] where ([Date-Time] between '2008-12-15 00:00' and '2008-12-15 01:00') and ([doors] = '1') order by [Date-Time]
|