ORDER BY clause: This clause is used to define the order of the query output either in ascending (ASC) or in descending (DESC). Ascending (ASC) is set as the default one but descending (DESC) is set explicitly.
Syntax:
SELECT column_name(s) FROM table_name WHERE condition ORDER BY column_name ASC|DESC; |
