SQL Language Reference

Ordering Multiple Columns

When ordering your data, you can have multiple sort levels. For example, you can order your data by city and then by name within the city.

Syntax:

Select fieldname, fieldname, fieldname
from tablename
order by fieldname <desc>, fieldname <desc>, fieldname <desc>

Explanation:

• By default, the Order By clause orders the specified fields in ascending order.
• Typing "desc" after a field name in the Order By clause tells SQL you want the data in the specified field displayed in descending order (Z to A, 100 to 1).
• The first field name specified is the primary sort order, the second field name specified is the secondary sort order, and so on ...

Retrieve the city, name, and vendor ID from the TrnVendor table. Order your data by city and then by name within city:

1. In the SQL text box, type:

Select City, Name, VendId
from TrnVendor
order by City, Name;

2. Execute the SQL statement.