[SQL] sum(bool)?

[Daniel Wickstrom]

>>>>> "Olaf" == Olaf Zanger <[EMAIL PROTECTED]> writes:

    Olaf> hi there i'd like to add up the "true" values of a
    Olaf> comparison like

    Olaf> sum(a>b)

    Olaf> it just doesn't work like this

    Olaf> any workaround

Try using a case statement:

select sum(case when  a > b then 1 else 0 end) ....


-Dan