sql report [message #39436] |
Wed, 17 July 2002 09:32 |
sverch
Messages: 582 Registered: December 2000
|
Senior Member |
|
|
I have a huge table m_cust (
M_CUST table:
prt_id,
dis_type,
sex,
......)
and I need counts for each sex for each dis_type and the result should look like this:
DIS_TYPE.......Female.....Male......Unknown
TT.....................2345......4567..........889
PP.....................6743.......923..........752
FF.....................4231.......8356.........122
If anybody was running something like this and has a query I will appriciate you help.
|
|
|
Re: sql report [message #39442 is a reply to message #39436] |
Wed, 17 July 2002 10:46 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
select dis_type,
sum(decode(sex, 'F', 1, 0)) female,
sum(decode(sex, 'M', 1, 0)) male,
sum(decode(sex, 'U', 1, 0)) unknown
from m_cust
group by dis_type;
|
|
|
|