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, 1531🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...