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

......