Posted by Arto V Viitanen on 09/20/07 06:29

Ed Murphy wrote:
> Terry Olsen wrote:
>
>> Yes, that works. But it doesn't show the row with no completes. So
>> unless a person has at least one complete, they won't show.
>> This will work for me, but is there a way to get it to include the
>> people with no completes?
>
> select Name, count(case Status when 'Complete' then 1 else 0 end)
> from <<tablename>>
> group by Name
> order by Name

I guess you meant


select Name, sum(case Status when 'Complete' then 1 else 0 end)
from <<tablename>>
group by Name
order by Name

--
Arto Viitanen

• Next in forum: Super Function II
• Prev in forum: Re: How to select count records that "contain" data?
• Thread view: Re: How to select count records that "contain" data?

[Reply to this message]