LIMIT and OFFSET

LIMIT restricts the number of rows returned. OFFSET skips a number of rows.

SELECT * FROM users LIMIT 5;

SELECT * FROM users LIMIT 5 OFFSET 10;

• LIMIT: Maximum number of results
• OFFSET: How many rows to skip before starting