"Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > [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; >
Yes, Igor, you are correct. I was thinking "sum" but my fingers hit "count". -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------