LIMIT

What it is

LIMIT bounds rows returned.

When to use it

Prevent unbounded list queries.

Syntax

SELECT id FROM orders ORDER BY id LIMIT 20 OFFSET 40;

Example

SELECT id, total_cents FROM orders
WHERE id > 100 AND user_id = 7
ORDER BY id LIMIT 20;
-- Keyset pagination avoids large OFFSET scans.

Common mistakes

LIMIT syntax differs by database; offset pagination can skip/duplicate rows during changes.

Related topics