From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Cc: David BOURIAUD <david.bouriaud@ac-rouen.fr>
Subject: Re: Help on a sql querry.
Date: Wed, 20 Jun 2001 13:13:00 -0400
Message-ID: <3.0.6.32.20010620131300.0239c760@pop6.sympatico.ca> (raw)
In-Reply-To: <3B272F9A.C8089ED6@ac-rouen.fr>
You might be looking for something like:
SELECT cod_eta,
SUM (CASE WHEN cod_sex='F' THEN 1 ELSE 0 END) AS female,
SUM (CASE WHEN cod_sex='M' THEN 1 ELSE 0 END) AS male
FROM can
GROUP BY cod_eta
ORDER BY cod_eta;
This should return rows containing: eta, female, male.
I might have made a typo tho...
Frank
At 11:17 AM 6/13/01 +0200, David BOURIAUD wrote:
>Hi the list !
>I've got a table in which I've got informations about persons.
>I'd like to know how many there are by etablissements, and the detail by
>sex.
>So, here is how my table is described :
>table can :
>num_can //candidate number
>nom_can //name
>...
>cod_sex //sex of candidate : M=Man, F = Woman
>...
>cod_eta // Etablissemnt where this person is.
>
>Any idea ? I'd like to avoid unions, cause it makes many lines for too
>few informations....
>Thanks by advance.
>--
>David BOURIAUD
>----------------------------------------------------------
>In a world without walls or fences, what use do we have
>for windows or gates ?
>----------------------------------------------------------
>ICQ#102562021
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: fbax@sympatico.ca, david.bouriaud@ac-rouen.fr
Subject: Re: Help on a sql querry.
In-Reply-To: <3.0.6.32.20010620131300.0239c760@pop6.sympatico.ca>
References: <3B272F9A.C8089ED6@ac-rouen.fr> <3.0.6.32.20010620131300.0239c760@pop6.sympatico.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox