Path: news.easynews.com!easynews!news.he.net!news-out.spamkiller.net!propagator2-maxim!propagator-maxim!news-in.spamkiller.net!snewsf0.syd.ops.aspac.uu.net!news1.optus.net.au!optus!news.optus.net.au!53ab2750!not-for-mail Newsgroups: comp.databases.oracle.server From: blah@blah.com (blah) Subject: Re: URGENT: sql group by clause has stopped working References: <3D52FE9F.4D260EA9@noaa.gov> X-Newsreader: News Xpress 2.01 Lines: 98 Message-ID: Date: Thu, 08 Aug 2002 23:37:29 GMT NNTP-Posting-Host: 203.15.126.10 X-Trace: news.optus.net.au 1028849849 203.15.126.10 (Fri, 09 Aug 2002 09:37:29 EST) NNTP-Posting-Date: Fri, 09 Aug 2002 09:37:29 EST Xref: easynews comp.databases.oracle.server:157312 X-Received-Date: Thu, 08 Aug 2002 16:34:36 MST (news.easynews.com) In article <3D52FE9F.4D260EA9@noaa.gov>, Thomas Gaines wrote: > >--------------EF80E3403A11EEF94CE21647 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Mr. Blah - > >Your "group by" clause is useless here. Why are you even including >it? This clause is meaningful only when you have a single-group >group function in your statement. Something like this is more helpful: > >select owner, count (*) >from smith >where job = 'comp' >and branch = '9' >group by owner; > >Tom Also I set up a test table called test: name name1 name2 chris po po chris po po chris po po Now I run : select name from test where name1 = 'PO' and name2 = 'PO' group by name; The result is: Chris No duplicates? Thanks > >blah wrote: > >> 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 > > > >--------------EF80E3403A11EEF94CE21647 >Content-Type: text/html; charset=us-ascii >Content-Transfer-Encoding: 7bit > > > >Mr. Blah - >

Your "group by" clause is useless here.  Why are you even including >
it?  This clause is meaningful only when you have a single-group >
group function in your statement.  Something like this is more >helpful: >

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

Tom >

blah wrote: >

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

> >
  > >--------------EF80E3403A11EEF94CE21647-- >