Limit the number of rows returned from sqlite

How do I limit the number of rows returned by activity.managedQuery ()?

I'm pretty sure there is no function in sqlite limit

. I also don't want to use SQLiteDatabase.query () because I am using URI to get my queries.


source to share

1 answer

Of course, SQLite has a LIMIT. See SQLite docs . For example:

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




All Articles