SQL Quick Reference

Displaying Rows in Descending Order

If you would like to see fields displayed in descending order, follow the field name with "desc" in the Order By clause.

Syntax:

Select */fieldname ...
from tablename
order by fieldname <desc> ...

Explanation:

• By default, the Order By clause tells SQL you want the field displayed in ascending order.
• Typing "desc" after the field name in the Order By clause tells SQL you want the data in the field displayed in descending order (Z to A, 100 to 1).

Retrieve the city, vendor ID, and name from the TrnVendor table. Order your data by city in descending order:

1. In the SQL text box, type:

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

2. Execute the SQL statement.