Count two different values from the same column
Hi guys,
i think this question is simple, but i get no idea to realize.
I have a table with 'Gender' column, so i need a query to count how many male and how many female are in the column. The column alloweed values are only 'm' and 'f'.
Any idea to realize this count with one query?
Probably the best way is to use alias...
Subject
Written By
Posted
Count two different values from the same column
December 02, 2010 03:19AM
December 02, 2010 06:47AM
December 02, 2010 07:41AM
December 03, 2010 01:04PM
December 03, 2010 01:44PM
December 03, 2010 04:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.