LIMIT & OFFSET

Pagination with limit and offset

Query

SQL

SELECT * FROM products ORDER BY price LIMIT 10 OFFSET 20;

What each clause does

LIMIT 10 returns at most 10 rows. OFFSET 20 skips the first 20 rows—useful for pagination.

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 ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)