Limit the number of rows returned from sqlite

Question

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.

+3

heero 27 Mar 12 at 19:37

1 answer

Julian · Accepted Answer · 2012-03-27T19:40:35+0000

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

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