6.12. SQL Select Limit

6.12.1. Limit Results

SELECT *
FROM astronauts
LIMIT 5;

6.12.2. Pagination

SELECT *
FROM astronauts
LIMIT 0, 10;
SELECT *
FROM astronauts
LIMIT 10, 10;
SELECT *
FROM astronauts
LIMIT 20, 10;