sum(bool)?

>>>>> "Olaf" == Olaf Zanger <olaf.zanger@soli-con.com> 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