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!
SanderHello 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment