SQL · Reading data

fetch first

Standard SQL pagination. PostgreSQL also supports LIMIT and OFFSET; SQLite only supports LIMIT.

sqlRunnable example sql course

Syntax

fetch first 10 rows only

Example

Open in the lab

-- Standard SQL: SELECT title FROM lessons FETCH FIRST 1 ROWS ONLY;
WITH lessons(title) AS (VALUES ('A'), ('B'))
SELECT title FROM lessons LIMIT 1;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.