Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    3

    Question Unanswered: Count of different values

    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

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •