9.7. SQL Select Limit

9.7.1. Limit Results

SELECT *
FROM astronauts
LIMIT 5;

9.7.2. Pagination

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