Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to calculate the total of a varchar column?

Re: How to calculate the total of a varchar column?

From: <isapmon_at_terra.es>
Date: 13 Feb 2006 08:36:23 -0800
Message-ID: <1139848583.887169.296670@f14g2000cwb.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US