Oracle - Sort the Query Output in Oracle

Sort the Query Output in Oracle

Q

How To Sort the Query Output in Oracle?

✍: 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
......

⇒Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2019-12-19, 607👍, 0💬

Select Some Columns from a Table in Oracle
How To Select Some Columns from a Table in Oracle? If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments": SQL> SELECT location_id, department_name FROM DEPA... 2019-12-19, 622👍, 0💬

Sort the Query Output in Oracle
How To Sort the Query Output in Oracle? 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; DE... 2019-12-19, 608👍, 0💬

Sort Query Output in Descending Order in Oracle
How To Sort Query Output in Descending Order in Oracle? If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the department in descending order, then sorts the salary in ascending order: SQL> SELE... 2019-12-19, 586👍, 0💬

Query Output Sorted by Multiple Columns in Oracle
Can the Query Output Be Sorted by Multiple Columns in Oracle? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: SQL> SELECT department_id, first_name, last_name, sala... 2019-12-19, 562👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.