Re: group by clause ordering

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 26 Apr 2007 16:49:10 +0200
Message-ID: <59bsenF2kd1biU1@mid.individual.net>

On 26.04.2007 16:31, DA Morgan wrote:

> mariegriffiths wrote:

>> Is there any way in which
>> select <blar>
>> from <blar>
>> group by a,b
>>
>> would not give the same results as same query with the columns in the
>> group by clause changed
>>
>> select <blar>
>> from <blar>
>> group by b,a
>>
>> Ignoring ordering.
>> I am thinking about null columns, duplicate rows min max, count
>> functions here.

>
> <blar>?

http://www.blackwellpublishing.com/journal.asp?ref=0261-3050&site=1

> Write real SQL and perhaps we can help you.

Real SQL for real DBA's. :-)

SCNR         robert

PS: It's so warm over here that my brain probably starts frying... Received on Thu Apr 26 2007 - 09:49:10 CDT