|
|
Posted by Ed Murphy on 09/19/07 23:19
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
Navigation:
[Reply to this message]
|