Limit number of rows returned from sqlite Limit number of rows returned from sqlite sqlite sqlite

Limit number of rows returned from sqlite


Of course there is LIMIT in SQLite. See the SQLite docs. For example:

SELECT col1, col2 FROM mytable WHERE foo = 'bar' LIMIT 42;