Using ORDER BY

Using ORDER BY

Syntax:
Select “column_name1″, “column_name2″,….”column_nameZ” FROM “table_name” order by age [asc|desc]

Example:
Example:
SELECT name, age FROM employee order by age asc

In the above example it displays all employees ordered by thier age in Ascending manner.