Hi,
I have a table containing only a bool filed. I would like to know how many
records there is an on many ar true.
Is there something I could do to get both answer in only one query... like
:
select count(*), sum(bool_col) from tablename
but there is no sum(bool) function that would add 1 if it's true and 0 if
it's false... ;(
Any idea?
Frédéric Boucher
dziablo(at)lords(dot)com