Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Limit and Offset

Select the first 10 rows from the penguins table:

SELECT *
FROM penguins
LIMIT 10;

Select the first 25% of rows from the penguins table:

SELECT *
FROM penguins
LIMIT 25%;

Select 10 rows from the penguins table, starting at position 5:

SELECT *
FROM penguins
LIMIT 10
OFFSET 5;