Path: news.easynews.com!easynews!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news1.optus.net.au!optus!news.optus.net.au!53ab2750!not-for-mail
Newsgroups: comp.databases.oracle.server
From: blah@blah.com (blah)
Subject: URGENT: sql group by clause has stopped working
X-Newsreader: News Xpress 2.01
Lines: 15
Message-ID: <mVC49.103$Ot2.12202@news.optus.net.au>
Date: Thu, 08 Aug 2002 23:12:18 GMT
NNTP-Posting-Host: 203.15.126.10
X-Trace: news.optus.net.au 1028848338 203.15.126.10 (Fri, 09 Aug 2002 09:12:18 EST)
NNTP-Posting-Date: Fri, 09 Aug 2002 09:12:18 EST
Xref: easynews comp.databases.oracle.server:157308
X-Received-Date: Thu, 08 Aug 2002 16:09:22 MST (news.easynews.com)

Hi All,

I can't figure this out.

select owner
from smith
where job = 'comp'
and branch = '9'
group by owner;

How can the above query return duplicates?

Thanks,
Wilk