8.7. SQL Select Limit

8.7.1. Limit Results

SELECT *
FROM astronauts
LIMIT 5;

8.7.2. Pagination

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