How To Sort the Query Output?
Page 1 of 1
How To Sort the Query Output?
by Micheal Sun Jan 17, 2010 3:02 am
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
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
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Sort Output in Descending Order?
» How To Name Query Output Columns?
» How To Divide Query Output into Groups?
» Can the Query Output Be Sorted by Multiple Columns?
» How To Set Up SQL*Plus Output Format?
» How To Name Query Output Columns?
» How To Divide Query Output into Groups?
» Can the Query Output Be Sorted by Multiple Columns?
» How To Set Up SQL*Plus Output Format?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL