Re: Help on a sql querry.

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(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>