Collections:
Sort Query Output in Descending Order in Oracle
How To Sort Query Output in Descending Order in Oracle?
✍: FYIcenter.com
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> SELECT department_id, first_name, last_name, salary FROM employees ORDER BY department_id DESC, salary; DEPARTMENT_ID FIRST_NAME LAST_NAME SALARY ------------- --------------- --------------- ---------- Kimberely Grant 7000 110 William Gietz 8300 110 Shelley Higgins 12000 100 Luis Popp 6900 100 Ismael Sciarra 7700 100 Jose Manuel Urman 7800 100 John Chen 8200 100 Daniel Faviet 9000 ......
2019-12-19, 706👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...