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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users