| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: sql group by clause has stopped working
Hi Blah,
What's the datatype of owner ?
Are you sure the values are identical (no hidden characters) ?
Try:
select dump(owner)
from smith
blah blah => I thought you might appreciate this :)
and confirm the values indeed are identical.
It is a little clearer if you write your query as
select distinct owner
from smith
blah blah
Cheers
Richard
blah wrote:
>
> In article <3D52FE9F.4D260EA9_at_noaa.gov>, Thomas Gaines <Thomas.Gaines_at_noaa.gov> 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
> >
> ><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> ><html>
> >Mr. Blah -
> ><p>Your "group by" clause is useless here. Why are you even including
> ><br>it? This clause is meaningful only when you have a single-group
> ><br>group function in your statement. Something like this is more
> >helpful:
> ><p><tt><font color="#FF0000">select owner, count (*)</font></tt>
> ><br><tt><font color="#FF0000">from smith</font></tt>
> ><br><tt><font color="#FF0000">where job = 'comp'</font></tt>
> ><br><tt><font color="#FF0000">and branch = '9'</font></tt>
> ><br><tt><font color="#FF0000">group by owner;</font></tt>
> ><p>Tom
> ><p>blah wrote:
> ><blockquote TYPE=CITE>Hi All,
> ><p>I can't figure this out.
> ><p>select owner
> ><br>from smith
> ><br>where job = 'comp'
> ><br>and branch = '9'
> ><br>group by owner;
> ><p>How can the above query return duplicates?
> ><p>Thanks,
> ><br>Wilk</blockquote>
> >
> ><br> </html>
> >
> >--------------EF80E3403A11EEF94CE21647--
> >
 |
 |