Re: [sqlite] Counting entries returned from a compound SELECT.

2012-06-21 Thread Igor Tandetnik
On 6/21/2012 4:07 PM, Peter Haworth wrote: Hoping someone can provide a way to return a count of the number of entries returned by a compound SELECT statement, specifically "SELECT …. EXCEPT SELECT….". select count(*) from (); -- Igor Tandetnik ___

Re: [sqlite] Counting entries returned from a compound SELECT.

2012-06-21 Thread Petite Abeille
On Jun 21, 2012, at 10:07 PM, Peter Haworth wrote: > returned by a compound SELECT statement, specifically "SELECT …. EXCEPT > SELECT….". select count( * ) from ( /* compound */ ) ? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Counting entries returned from a compound SELECT.

2012-06-21 Thread Peter Haworth
Hoping someone can provide a way to return a count of the number of entries returned by a compound SELECT statement, specifically "SELECT …. EXCEPT SELECT….". Thanks, Pete lcSQL Software ___ sqlite-users mailing list