SQL ORDER BY Multiple Columns

Example:

ORDER BY last_name, first_name:
SELECT * FROM users
ORDER BY last_name ASC, first_name ASC

Mixed sort:
ORDER BY created_at DESC, name ASC

Sort by multiple columns: ORDER BY col1, col2. First column is primary sort, second is tiebreaker. Use ASC (ascending) or DESC (descending).

Try SQL Beautifier →

FAQs

What is the default sort order?

ASC (ascending) is default. Explicitly use DESC for descending.