sum orders for each hour in hours

[khaled1988]

hi
i'm stack in query problem i need sql query that can sum(orders columns)for each hour in day

the result is like this

date/time | order | doors | center

11/02/2008 08:12:20 | 1 | 1 | ----
11/02/2008 08:12:22 | 3 | 2 | ----
11/02/2008 08:12:23 | 1 | 2 | ----

i want it like this

date/time | order | doors | center

11/02/2008 09:00 | 1 | 1 | ----
11/02/2008 09:00 | 4 | 2 | ----

[Frinavale]

You can use the SQL SUM() Function to calculate the sum of a column.

Use a WHERE clause to specify which times should be added together.


Please attempt to create your SQL query. Use something like Query Analyzer to test your SQL query...If you are still having problems with it, please post what you have tried so far. Please remember to use code tags when posting code snippets.


-Frinny

[balabaster]

Is this a SQL question or an ASP.NET question? Do you need to do this in an application or on the SQL Server itself?

If you're doing it in the SQL Server, this question should be moved to the SQL Server forum...

[r035198x]

I'd have moved it if I knew for sure which database they are using.

[Frinavale]

@r035198x
I was waiting for the OP to reply with more details :)