MySQL Forums
Forum List  »  General

Count two different values from the same column
Posted by: Santino Puleio
Date: December 02, 2010 03:19AM

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...

Options: ReplyQuote


Subject
Written By
Posted
Count two different values from the same column
December 02, 2010 03:19AM


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.