Re: URGENT: sql group by clause has stopped working

From: blah <blah_at_blah.com>
Date: Thu, 08 Aug 2002 23:33:09 GMT
Message-ID: <VcD49.105$Ot2.12202@news.optus.net.au>

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

Thanks Tom but how come the above query has been working fine for months and has suddenly started returning duplicates? This query also works on the development database?

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 -
>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:
><tt>select owner, count (*)</tt>
> <tt>from smith</tt>
> <tt>where job = 'comp'</tt>
> <tt>and branch = '9'</tt>
> <tt>group by owner;</tt>
>Tom
>blah wrote:
><blockquote TYPE=CITE>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</blockquote>
>
>  </html>
>
>--------------EF80E3403A11EEF94CE21647--
>
Received on Thu Aug 08 2002 - 18:33:09 CDT