This statement is used to sort the desired results in ascending or descending order. By default, the results would be sorted in ascending order. If you want the records in the result-set in descending order, then use the DESC keyword.
SELECT column1, column2, ...
ORDER BY column1, column2, ... ASC|DESC;