Received: from all.all.ee (puu.all.ee [194.204.49.113]) by hub.org (8.10.1/8.10.1) with ESMTP id e65C1xS84224 for ; Wed, 5 Jul 2000 08:02:01 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id PAA15308 for ; Wed, 5 Jul 2000 15:01:45 +0300 Date: Wed, 5 Jul 2000 15:01:44 +0300 (EEST) From: Antti Linno To: pgsql-sql@postgresql.org Subject: Group BY ...(cont.) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200007/31 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.