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.