SQL
Implementing Efficient Pagination in SQL
Learn how to retrieve a specific page of results from a large dataset using OFFSET and LIMIT clauses for efficient SQL database pagination.
SELECT id, name, created_at
FROM products
ORDER BY created_at DESC
LIMIT 10 OFFSET 20;
How it works: This query retrieves a specific subset of rows from the `products` table, ordered by `created_at` in descending order. The `LIMIT` clause specifies the maximum number of rows to return (10), while `OFFSET` specifies how many rows to skip from the beginning of the result set (20), effectively fetching the third page of results assuming 10 items per page. This approach is widely used for pagination in web applications.