Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!pln-e!spln!dex!extra.newsguy.com!newsp.newsguy.com!news.usenetgateway.com
From: roobaron <member@dbforums.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: URGENT: sql group by clause has stopped working
Date: 9 Aug 2002 02:20:50 GMT
Organization: dBforums
Lines: 17
Sender: roobaron
Message-ID: <1680093.1028857449@dbforums.com>
References: <mVC49.103$Ot2.12202@news.optus.net.au>
NNTP-Posting-Host: p-592.newsdawg.com
User-Agent: forums@dbforums.com
X-Original-NNTP-Posting-Host: ns.spikeball.com
X-Original-Trace: 9 Aug 2002 02:20:50 GMT, ns.spikeball.com
Xref: easynews comp.databases.oracle.server:157322
X-Received-Date: Thu, 08 Aug 2002 19:47:11 MST (news.easynews.com)


try

select owner
from smith
where job = 'comp'
and branch = '9'
group by owner
having count(owner) > 1;

The HAVING clause is useful in determining dupes.

Have Fun

--

Posted via dBforums\nhttp://dbforums.com