How To Sort the Query Output

Q

How To Sort the Query Output? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements

✍: FYIcenter.com

A

If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The following select statement returns rows sorted by the values in the "manager_id" column:

SQL> SELECT * FROM departments ORDER BY manager_id;
DEPARTMENT_ID DEPARTMENT_NAME      MANAGER_ID LOCATION_ID
------------- -------------------- ---------- -----------
           90 Executive                   100        1700
           60 IT                          103        1400
          100 Finance                     108        1700
           30 Purchasing                  114        1700
           50 Shipping                    121        1500
           80 Sales                       145        2500
           10 Administration              200        1700
           20 Marketing                   201        1800
......

2007-04-20, 4894👍, 0💬