That seems to be the answer and after some quick testing it looks it makes it more efficient as well!
RBS On Tue, Oct 18, 2011 at 1:36 PM, Kit <[email protected]> wrote: > 2011/10/16 Fabian <[email protected]>: >> How can you limit a count-query? I tried: >> SELECT COUNT(*) FROM table LIMIT 5000 > > SELECT min(COUNT(*),5000) FROM table; > -- > Kit > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
