[sqlite] Re: multiple selects in a single prepare

[Igor Tandetnik]

[EMAIL PROTECTED] wrote:
SELECT count(state='Normal'), count(state='Critical') FROM tbl1;

Wouldn't that just return the number of all rows in tbl1, twice? That 
probably should be

SELECT sum(state='Normal'), sum(state='Critical') FROM tbl1;

Igor Tandetnik 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------