Lesson 9: Displaying Rows in Descending Order in SQL

	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). Example: Retrieve the city, vendor ID, and name from the TrnVendor table. Order your data by city in descending order: In the SQL text box, type: Select City, VendId, Name  from TrnVendor order by City desc; Execute the SQL statement. Results   City VendId Name Youngstown TV018 Computer Bytes Warren TV002 The Games All Here Toledo TV027 Narrow Nest Toledo TV014 Counter Productive Toledo TV009 Hit the Deck Toledo TV001 Wet Off Towels Park Ridge TV015 No Waste Disposal