SQL
Fetching Paginated Results from a Database
Learn how to efficiently retrieve a specific range of records from a large dataset for pagination using LIMIT and OFFSET clauses in SQL, improving web application performance.
SELECT id, name, created_at
FROM products
WHERE category_id = 123
ORDER BY created_at DESC
LIMIT 10 OFFSET 20;
How it works: This SQL query demonstrates how to retrieve a specific 'page' of results from a table. `LIMIT 10` fetches a maximum of 10 rows, and `OFFSET 20` skips the first 20 rows. Combined, this effectively retrieves the third page of data, assuming each page displays 10 items. This technique is fundamental for implementing pagination in web applications, allowing for efficient browsing of large datasets.