ORDER BY and Sorting

ORDER BY sorts the result by one or more columns.

SELECT * FROM users ORDER BY age ASC;

• ASC: Ascending (default)
• DESC: Descending

Example:

SELECT name, age FROM users ORDER BY age DESC;