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 contactsORDER BY birth_date DESC;