Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.10.1/8.10.1) with ESMTP id e65CJaS29490 for ; Wed, 5 Jul 2000 08:19:36 -0400 (EDT) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id FAA29154; Wed, 5 Jul 2000 05:15:13 -0700 From: "tjk@tksoft.com" Message-Id: <200007051215.FAA29154@uno.tksoft.com> Subject: Re: Group BY ...(cont.) To: alligator@all.ee (Antti Linno) Date: Wed, 5 Jul 2000 05:15:12 -0700 (PDT) Cc: pgsql-sql@postgresql.org In-Reply-To: from "Antti Linno" at Jul 5, 0 03:01:44 pm Content-Type: text X-Archive-Number: 200007/34 E.g. select workgroup from job group by workgroup; will that do? Troy > > Ok, if I want to use group by, then I have to put every select field > afterwards to group by. But I do want to group by one field. > Hence > select workgroup,id from job group by workgroup,id; > would create groups of 1? > But I want to group by workgroups. > Sorry if my explanation is fuzzy. > A. > > >