The MYSQL ORDER BY Clause is used to sort the records in ascending or descending order.
ORDER BY expression [ ASC | DESC ];
expressions: It specifies the columns that you want to retrieve.
tables: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause.
WHERE conditions: It is optional. It specifies conditions that must be fulfilled for the records to be selected.
ASC: It is optional. It sorts the result set in ascending order by expression (default, if no modifier is provider).
DESC: It is also optional. It sorts the result set in descending order by expression.