Collections:
Sort the Query Output in Oracle
How To Sort the Query Output in Oracle?
✍: FYIcenter.com
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 ......
⇒ Query Output Sorted by Multiple Columns in Oracle
⇐ Select Some Rows from a Table in Oracle
2019-12-19, 1420🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...