Order by

[sparkme]

Sql Friends ,
I want to write a sql query to order the daily orders by date as well as number of orders per hour.Please help.

Thanks
Spark

 

[onpnt]

What have you got so far?

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[monksnake]

order the daily orders by date as well as number of orders per hour

Here you go:

Select daily orders from the table with daily orders in it order by date as well as number of orders per hour.

*Not tested

<.

 

[sparkme]

Friends I found the answer to this by myself.I added a column to the table (Table variable for temp result)
called DateId Which will be having id on the basis of DATETIME VALUE in the Order table Then I can order on the basis of DateId

 

[sparkme]

I came to know that

There is No need to add a column on the basis of Datetime value I can use the function in the
SELECT DATEPART(hh,DateAdd)
and group by DATEPART(hh,DateAdd)


Thanks