LIMIT clause
Limit the number of rows returned by query. The clause also sets offset from which the limit on rows is applied. Read sqlite docs
Syntax: LIMIT <limit> [OFFSET <offset>]
-- return only 10 rows.
SELECT 1 FROM meta.ECClassDef LIMIT 10
-- return only 10 rows from offset 10
SELECT 1 FROM meta.ECClassDef LIMIT 10 OFFSET 10
Last Updated: 29 April, 2025
Found something wrong, missing, or unclear on this page? Raise an issue in our repo.