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
ELSE0 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
>