5.11. SQL Select Limit

5.11.1. Limit Results

SELECT *
FROM astronauts
LIMIT 5;

5.11.2. Pagination

SELECT *
FROM astronauts
LIMIT 0, 10;

SELECT *
FROM astronauts
LIMIT 10, 10;

SELECT *
FROM astronauts
LIMIT 20, 10;