Re: URGENT: sql group by clause has stopped working

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
Received on Thu Aug 08 2002 - 18:28:31 CDT