counting column in database mysql

Question

how can i count the value of two different column in database?

example:

i have a table hospital which have a column , hosptal_id and sex

now i want a result that count the the sex column by type, (male or female) within a hospital

i want the result something like..

hospital_id ------ F ------ M

1 ----------------- 14----- 45

2 ----------------- 23----- 49

3 ----------------- 29------ 76

, how can i get this result?

is anybody can help me on this?

sel · Accepted Answer · 2012-07-17 06:35:44Z

2

SELECT id,SUM(IF(sex='M',1,0)) AS 'male', 
SUM(IF(sex='F',1,0)) AS 'female' 
FROM hospital 
GROUP BY id

answered Jul 17, 2012 at 6:35

sel

4,9421 gold badge18 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

swapnesh · Accepted Answer · 2012-07-17 06:25:29Z

0

Try query like this--

SELECT COUNT(DISTINCT column_name) AS some_alias FROM table_name

answered Jul 17, 2012 at 6:25

swapnesh

26.8k24 gold badges97 silver badges129 bronze badges

i want to count the value of sex individually.