CREATE TABLE log (id INTEGER, message TEXT); INSERT INTO log VALUES (1, 'start'), (2, 'load'), (3, 'run'), (4, 'stop'); -- LIMIT returns at most N rows, handy for a quick look SELECT id, message FROM log LIMIT 2;
LIMIT caps the row count