ORDER BY

BrandonDusch580 total contributions
Published Jun 4, 2021Updated Jul 13, 2022
Contribute to Docs
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;
All contributors
- BrandonDusch580 total contributions
- christian.dinh2481 total contributions
- Anonymous contributorAnonymous contributor3077 total contributions
- BrandonDusch
- christian.dinh
- Anonymous contributor
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.