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 <kit.sa...@gmail.com> wrote: > 2011/10/16 Fabian <fabianpi...@gmail.com>: >> 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users