ORDER BY

The ORDER BY command sorts the result set by a particular column either alphabetically or numerically.

Syntax

SELECT column_name
FROM table_name
ORDER BY column_name ASC | DESC;

ORDER BY can be set in two ways:

• ASC is a keyword used to sort the results in ascending order (default).
• DESC is a keyword used to sort the results in descending order.

Example

The query below will sort by birth_date, in descending order:

SELECT *
FROM contacts
ORDER BY birth_date DESC;