Re: URGENT: sql group by clause has stopped working

Hi Wilk,

after receiving a lot of answers off-topic:

this query can return duplicates if you have corruption in either your table or your index. Otherwise, it logically can only return at most one row.

HTH. Regards,

Martin

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 Mon Aug 12 2002 - 00:45:44 CDT