Summing Row in SQL query for time range
- by user3703334
I'm trying to group a large amount of data into smaller bundles.
Currently the code for my query is as follows
SELECT [DateTime]
,[KW]
FROM [POWER]
WHERE datetime >= '2014-04-14 06:00:00' and datetime < '2014-04-21 06:00:00'
ORDER BY datetime
which gives me
DateTime KW
4/14/2014 6:00:02.0 1947
4/14/2014 6:00:15.0…
