Ordering columns in SQL?

TheDrummer · Joined: 11 Oct 2004 Posts: 4

Hi,

I have a SQL table called Sales with several colums, including OrderDate and Amount. I want to select everything from the Sales table, but I want it ordered by OrderDate first and then by Amount. So if you have 3 sales today, and 2 yesterday the result will look like:

10/27/2004 $150.00
10/27/2004 $300.00
10/28/2004 $100.00
10/28/2004 $120.00
10/28/2004 $130.00

I'll need help with this please.

Thanks,

John

administrator · Site Admin Joined: 01 Oct 2004 Posts: 183

The following SQL statement will do:

TheDrummer · Joined: 11 Oct 2004 Posts: 4

Thanks a lot man!

rose · Joined: 21 Feb 2006 Posts: 29

You can also add an ASC or DESC on to the end of that, to notify of ascending or descending order.

I may have got those abbreviations wrong, so check up on it.