Posted by Andy Hassall on 04/01/07 16:04

On 29 Mar 2007 09:57:17 -0700, "C." <colin.mckinnon@gmail.com> wrote:

>First off, apologies for posting here - I can't find a dedicated
>SQLite newsgroup
>
>The other thing I can't find is how to retrieve the total number of
>rows which would have been returned by a query if it did not have a
>LIMIT and/or OFFSET clause.
>
>(kind of like SQL_CALC_FOUND_ROWS/FOUND_ROWS() in MySQL)

I don't see one from a quick flick through the manual - you'll probably have
to issue another similar query with a count(*) and no limit clause.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]