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

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