SQL
Paginate Query Results with LIMIT and OFFSET
Learn to efficiently retrieve subsets of data from your database using LIMIT and OFFSET, crucial for implementing pagination on web applications.
SELECT id, name, created_at
FROM articles
WHERE published = TRUE
ORDER BY created_at DESC
LIMIT 20 OFFSET 40;
How it works: This SQL snippet is fundamental for implementing pagination in web applications. `LIMIT` specifies the maximum number of rows to return (e.g., 20 items per page), while `OFFSET` determines how many rows to skip from the beginning of the result set (e.g., skipping 40 rows to get to the third page when each page has 20 items). It's typically used with `ORDER BY` to ensure consistent ordering.