quick question

I have a data like ....

ID Alias Date
45 Order 1 12/01/2005
49 Order 2 12/01/2005
46 Order 3 12/01/2005
50 Order 4 12/02/2005
55 Order 5 12/02/2005

I want to add one column at the above result set and result set should look
like ...

ID Alias Date OrderNum
45 Order 1 12/01/2005 1
49 Order 2 12/01/2005 2
46 Order 3 12/01/2005 3
50 Order 4 12/02/2005 1
55 Order 5 12/02/2005 2

I want to generate the orderNum based on date.

Thanks in advance


.

Loading