MySQL sorting data from table :
MySQL allow us to view data from table in a sorted order. The rows retrieved from the table will be sorted in either ascending order or descending order depending on given condition.
Note : to sort data as ascending use “asc” and descending use “desc”.
select * from <table_name> order by <column_name> <[sorting_order]>;
Suppose you want to view data from table as salary in descending order. So you will have to write query as follows…
select * from employee order by salary desc;