SQL
Paginate Query Results Using LIMIT and OFFSET
Learn to efficiently retrieve subsets of data for pagination by specifying the number of rows to return and the starting offset, crucial for large datasets.
SELECT id, title, created_at
FROM posts
WHERE status = 'published'
ORDER BY created_at DESC
LIMIT 10 OFFSET 20;
How it works: This query shows a standard way to implement pagination in SQL databases. `LIMIT` specifies the maximum number of rows to return (page size), and `OFFSET` specifies the number of rows to skip from the beginning of the result set. In this example, it fetches 10 published posts, starting after the first 20 (i.e., page 3 if page size is 10), ordered by creation date in descending order. This is vital for displaying manageable chunks of data in web applications.