Re: GROUP by - Mailing list pgsql-sql

From Jerome Alet
Subject Re: GROUP by
Date
Msg-id Pine.LNX.3.96.1000705134903.22213A-100000@cortex.unice.fr
Whole thread Raw
In response to GROUP by  (Antti Linno <alligator@all.ee>)
List pgsql-sql
On Wed, 5 Jul 2000, Antti Linno wrote:

> I have table job, and I want to select data from it, grouping by
> workgroups. When I use 
>  select id,name from job where workgroup='top leaders' AND ...  group by
> workgroup;

this query is probably incorrect: because of the "where workgroup=" the
"group by workgroup" can't do anything.

bye,

Jerome ALET - alet@unice.fr - http://cortex.unice.fr/~jerome
Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 
28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE




pgsql-sql by date:

Previous
From: Antti Linno
Date:
Subject: GROUP by
Next
From: Antti Linno
Date:
Subject: Group BY ...(cont.)