ORDER BY

What it is

ORDER BY defines result ordering.

When to use it

Make lists deterministic and pagination stable.

Syntax

ORDER BY created_at DESC, id DESC

Example

SELECT id, total_cents FROM orders
WHERE user_id = 7
ORDER BY created_at DESC, id DESC LIMIT 20;

Common mistakes

Without ORDER BY row order is unspecified; whitelist user-selected sort columns.

Related topics