* Igor Tandetnik <[EMAIL PROTECTED]> [2006-12-29 17:35]:
> Why not
>
> select state, count(*)
> where state in ('Normal', 'Critical')
> group by state;
>
> ?
Clever!
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2006-12-29 17:40]:
> SELECT count(state='Normal'), count(state='Critical') FROM tbl1;
How exactly does this work? I assume it involves data type
coercion, but what are the rules and effects?
Regards,
--
Aristotle Pagaltzis // <http://plasmasturm.org/>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
