ORDER BY clause.
In a SELECT statement, this SQL clause is used to sort result set based data on several columns in a descending or an ascending order. The default syntax for using this clause to sort data is shown as below:
SELECT column-list
FROM table_name [WHERE condition]
[ORDER BY column1 [, column2, .. columnN] [DESC]];