Order by clause

Order by clause

Order by clause used in select statement to sort the data in ascending or descending order.

Order by clause is based on one or more columns.

Oracle and sql sort resultset into ascending order by default

To display data in descending order we need to add DESC at end.

Ascending

select * from Employees order by 1 desc

Descending

select * from Employees order by 1

select * from Employees order by 1,2

select * from Employees order by 1,2 desc

select * from Employees order by EmployeeID desc

in above case order by 1 sorts the data on first column of the table. We can sort the data on the basis of  column no or name.