Basic Oracle Concepts and Programming Question: Download Questions PDF
How To Sort the Query Output in Oracle?
Answer:
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;
<pre>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
......</pre>
SQL> SELECT * FROM departments ORDER BY manager_id;
<pre>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
......</pre>
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Select Some Rows from a Table in Oracle? | Can the Query Output Be Sorted by Multiple Columns in Oracle? |