ORDER BY

Sort results by columns

Query

SQL

SELECT name, age FROM users ORDER BY age DESC, name ASC;

What each clause does

ORDER BY sorts results. age DESC sorts by age descending; name ASC breaks ties by name ascending.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET