SQL
Implement Database Pagination with OFFSET and LIMIT
Learn to paginate large datasets efficiently in SQL using OFFSET and LIMIT, essential for displaying results on web pages without fetching all records.
SELECT
id,
name,
created_at
FROM
products
ORDER BY
created_at DESC
LIMIT 10 OFFSET 20;
How it works: This SQL query demonstrates a common method for pagination. It selects `id`, `name`, and `created_at` from the `products` table, orders them by `created_at` in descending order, then retrieves 10 records (`LIMIT 10`) starting after the first 20 records (`OFFSET 20`). This effectively fetches the third page of results (assuming 10 items per page).