pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>



view thread (2+ messages)

Message-ID: <3.0.6.32.20010620131300.0239c760@pop6.sympatico.ca>
Permalink:  ../3.0.6.32.20010620131300.0239c760@pop6.sympatico.ca/
Also on:    postgresql.org/message-id/3.0.6.32.20010620131300.0239c760@pop6.sympatico.ca

 · 

reply

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