Pagination

Limit

The LIMIT clause limits the amount of rows returned by the query.

SELECT * FROM table_name LIMIT 10

Offset

The OFFSET clause offsets the rows returned by the query.

SELECT * FROM table_name LIMIT 10 OFFSET 10