Retriving data in single select statement

[sylwesters]

Hi you could try something like this:

select name,
count(case when status='closed' then 1 else 0 end) as Closed,
count(case when status='open' then 1 else 0 end) as Open
from
tablename
group by name

Hope it will help,
S.