another aproach is to use OFFSET and LIMIT in your select queries: select * from table limit 100 offset 1
then select * from table limit 100 offset 101 then select * from table limit 100 offset 201 etc. Shailesh Madhukar Birari escribió: > Does Sqlite support Paged query? what I mean is on doing select* it should > return me first, say 100, rows and then subsequent calls should return me > successive rows. > Is this supported in sqlite:? If yes, what are the interfaces? > If not, is there an easy way to add this functionality using existing > interfaces? > > regards. > Shailesh > _______________________________________________ > 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