Help on a sql querry. - Mailing list pgsql-sql

From David BOURIAUD
Subject Help on a sql querry.
Date
Msg-id 3B272F9A.C8089ED6@ac-rouen.fr
Whole thread Raw
Responses Re: Help on a sql querry.
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: Re: [ADMIN] Row Level Locking !!
Next
From: Peter Eisentraut
Date:
Subject: Re: possible to lock a single row in table?