CREATE TABLE book (id INTEGER, title TEXT);
INSERT INTO book VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'Gamma'), (4, 'Delta');
-- OFFSET discards the first N rows before LIMIT applies
SELECT title
FROM book
ORDER BY id
LIMIT 2 OFFSET 1;

OFFSET skips leading rows