降序排序-Oracle 9i基础教程

降序排序 SQL:

SELECT ename, job, deptno, hiredate 
FROM temp 
ORDER BY hiredate DESC;

结果：

ENAME     JOB       DEPTNO  HIREDATE 
----      --------- -------- ----------- 
ADAMS    CLERK     20      12-JAN-83 
SCOTT    ANALYST   20      09-DEC-82 
MILLER   CLERK     10      23-JAN-82 
JAMES    CLERK     30      03-DEC-81 
FORD     ANALYST   20      03-DEC-81 
KING     PRESIDENT 10      17-NOV-81 
MARTIN   SALESMAN  30      28-SEP-81 
... 14 rows selected.