MySQL SQL
MySQL LIMIT
Restrict the number of rows returned.
Limit and paginate
SELECT * FROM products
ORDER BY id
LIMIT 10 OFFSET 20;LIMIT sets the maximum row count and OFFSET skips rows. Use ORDER BY for stable pagination.
MySQL SQL
Restrict the number of rows returned.
SELECT * FROM products
ORDER BY id
LIMIT 10 OFFSET 20;LIMIT sets the maximum row count and OFFSET skips rows. Use ORDER BY for stable pagination.