Re: [SQL] sum(bool)?

[Tod McQuillin]

On Fri, 23 Feb 2001, Olaf Zanger wrote:

> i'd like to add up the "true" values of a comparison like
>
> sum(a>b)
>
> it just doesn't work like this

Try

 sum(case when a>b then 1 else 0 end)
-- 
Tod McQuillin