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 ......
2019-12-19, 724👍, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...