SQL
Public
Select Rows with Pagination
A basic SQL pagination query using LIMIT and OFFSET.
#sql
#pagination
#query
#beginner
SQL
SELECT id, title, created_at
FROM blog_posts
WHERE is_published = 1
ORDER BY created_at DESC
LIMIT 20 OFFSET 40;Notes
OFFSET 40 with LIMIT 20 returns the third page when the page size is 20.
