Order By Clause

Order By Clause

Order By Clause are used to arrange the data either in ascending or descending order. Bydefault order by clause arrange or short the data in ascending order. To sort the records in a descending order, you can use the DESC keyword.

Note: You can apply order by clause on more than one column in the same table

	
SELECT column_name, column_name
FROM table_name
ORDER BY column_name ASC|DESC, column_name ASC|DESC;

Example Order by

Employee table

After apply join on these two table, result show like below;

	
SELECT * FROM Employee
ORDER BY name;

Result after apply order by on Employee table.

Order by in descending order

This is an example to sort the result in descending order by age.

	
SELECT * FROM Employee
ORDER BY salary DESC;

Result after apply order by on Employee table.