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
