SQL · Reading data

order by

Sorts the result. Add a unique tie-breaker for stable pagination.

sqlRunnable example sql course

Syntax

order by column desc

Example

Open in the lab

WITH lessons(title, minutes) AS (VALUES ('HTML', 12), ('CSS', 18))
SELECT title FROM lessons ORDER BY minutes DESC, title ASC;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.