I want to display record in this format PATIENT_CODE,gender,Malecount,femalecount

[Swapnil Mestry]

I want to display record in this format:

PATIENT_CODE,gender,Malecount,femalecount

Select PATIENT_CODE,gender,count(*)
From BABY_MASTER Where Patient_Code='KBB-04-2010-96'
group by PATIENT_CODE,SEX

This query shows Patient_code,gender,count, if there is 4 record for particular patient.

I want to display record in one row that should be in this format:

Patient_code,Malecount,femalecount

Can anybody help me with the solution?

Thanks in advance.

[ck9663]

What's the name of the column for gender? Is it Gender or Sex? You have gender in the select list but Sex in Group By.

~~ CK

[Sandeep M]

select PATIENT_CODE,sum(Fcount) as Fcount,sum(Mcount) as Mcount from
(
Select PATIENT_CODE,case gender when 'F' then 1 else 0 end as Fcount,case gender when 'M' then 1 else 0 end as Mcount
From BABY_MASTER Where Patient_Code='KBB-04-2010-96'
) cur group by PATIENT_CODE