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, 1895🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...