MVSFORUMS.com

[salimo]

In DB2 SPUFI,
Is there a way to total(SUM) the result of PEOPLE_CNT in the same query? To get the SUM for both Male and Female?NOTE:
The SUM function against the alias PEOPLE_CNT does not work !!!!

THANK YOU.

See below query of SUMS, I would like to SUM the Aliases counts
SELECT COL1, COL2, COUNT(COL1) AS PEOPLE_CNT
FROM TABLE1
GROUP BY COL1, COL2;
Result set
=============================================
Col1 Col2 PEOPLE_CNT
1234 Male 89798709887
3456 Female 78639877683

[kolusu]

Salimo,

Can you show us a sample data and your expected out put from the query?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Cathygomez]

Salimo,
Try this...

SELECT SUM(PEOPLE_CNT)
FROM
(SELECT COL1, COL2, COUNT(COL1) AS PEOPLE_CNT
FROM TABLE1
GROUP BY COL1, COL2) as X

HTH