Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to calculate the total of a varchar column?
Hi:
you can use an union:
SELECT GENDER, COUNT(GENDER) As American_Indian
FROM STUDENT_DETAIL
WHERE ETHNIC_GROUP_CODE = 1
GROUP BY GENDER
union
SELECT 'MF',COUNT(*)
FROM STUDENT_DETAIL
WHERE ETHNIC_GROUP_CODE = 1 AND GENDER IN ('M','F')
ORDER BY GENDER DESC
I hope it's useful to you.
Regards,
Isa
Received on Mon Feb 13 2006 - 10:36:23 CST