Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Paginate with LIMIT and OFFSET

Skip rows and return a page-sized result set.

Back to sheetBrowse commands
Sign in to save
Section: Sorting and Limiting

Paginate with LIMIT and OFFSET

sql
sql
SELECT *
FROM posts
ORDER BY published_at DESC
LIMIT 20 OFFSET 40;
Explanation

Offset pagination is simple but can be slower for large offsets.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Sorting and Limiting
Limit returned rows
Return only the first N rows.
OpenIn sheetsqlsame section
Fetch first rows
Use standard SQL row limiting syntax.
OpenIn sheetsqlsame section
Sort rows
Order query results ascending or descending.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.
OpenIn sheetsql
Filter with equality
Return rows matching an exact value.
OpenIn sheetsql
Inner join two tables
Return rows with matches in both tables.
OpenIn sheetsql