You can do this only by issuing 2 different queries - one with count(*) and another selecting first 10 rows.
Pavel On Tue, Apr 6, 2010 at 8:39 AM, David Hamm <[email protected]> wrote: > Hi, > > I'd like to use a query like "select * from table limit 0,10" but I also need > the number of rows that would have been returned without a limit/offset being > in the query. > > I tried select count( *),* from table but that only returns 1 row. > > Thanks, > _______________________________________________ > 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
