Order by Two Columns
Here's how to order by more than one column. When ordering by more than
one column, the second column is only used if the values are identical with
the onces in the first column:
SELECT column_name(s)
FROM table_name
ORDER BY column_name1, column_name2
Sort the display by Ascending or Descending Order
If you use the ORDER BY keyword, the sort-order of the recordset is ascending
by default (1 before 9 and "a" before "p").
Use the DESC keyword to specify a descending sort-order (9 before 1 and "p" before "a"):
SELECT column_name(s)
FROM table_name
ORDER BY column_name DESC
NewSourceMedia is providing links to these listings as
a courtesy, and makes no representations regarding the content or
any information related thereto. Any questions, complaints or claims
regarding the downloaded content or details must be directed to the appropriate
publisher. We do not encourage or condone the use of any
software in violation of applicable laws.
CATEGORIES
