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 ......
⇒ Count the Number of Rows with SELECT Statements in Oracle
⇐ Query Output Sorted by Multiple Columns in Oracle
2019-12-19, 1530🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...