ORDER by This then That - possible?

[jimoblak]

I want to display the contents of a record set based on the order of state, then by the order of city in each state. Is there a simple ORDER by command that can pull this off?

Like:
SELECT State, City FROM Addresses ORDER by State, City

Expected output:
Ohio Cincinnati
Ohio Columbus
Ohio Dayton
Oklahoma Pierpont
Utah Salt Lake City

 

[jimoblak]

DOH!

I just tried my sample query and it worked. Sometimes my ignorance impresses myself.

ASC and DESC can be also used immediately after the column name to sort by ASCending or DESCending order.