PDA

View Full Version : Count of different values


SandervdM
02-25-02, 05:58
Hi all,

I have a table in which there is a column that can only contain two values: Male and Female.

How should I write a query that will give me a total of both Male and Female?

For example: Male: 23 Female:27

Thanks!

Sander

alligatorsql.com
02-25-02, 07:05
Hello Sander,

this is a SQL statement that give you the needed datas in two records

select MaleFemale, count(1) from statistic
group by MaleFemale

Is that good for you ?

Greetings
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com