Temple University

Order By SalePrice Descending. The DESCENDING at the end of the ORDER BY clause orders the list in descending order instead of the default (ascending) order. You can also use ORDER BY on more than one field. To order the sales by roll and then by saledate you would type: Select Roll, SaleDate, SalePrice. From SalesHeader. Order By Roll ... ................
................