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, 1419🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...