Descending order

You can retrieve results in descending order by specifying DESC in the ORDER BY clause.

For example, this query retrieves department numbers, last names, and employee numbers in descending order of department number:

SELECT DEPT, LASTNAME, EMPNO
  FROM EMP
  WHERE JOB = 'SLS'
  ORDER BY DEPT DESC;

The result table looks like this:

DEPT     LASTNAME     EMPNO
====     =========    ======
C01      NICHOLLS     000140
A00      HEMMINGER    200010
A00      CONNOR       000120