Re: group by clause ordering

From: DA Morgan <damorgan@xxxxxxxxx>
Date: Thu, 26 Apr 2007 07:31:00 -0700

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>?

Write real SQL and perhaps we can help you.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Follow-Ups:
- Re: group by clause ordering
  - From: Thorsten Kettner
- Re: group by clause ordering
  - From: Robert Klemme

References:
- group by clause ordering
  - From: mariegriffiths

Prev by Date: group by clause ordering
Next by Date: Re: ORA-12514 - afer installing Patch
Previous by thread: group by clause ordering
Next by thread: Re: group by clause ordering
Index(es):
- Date
- Thread

Relevant Pages

Re: group by clause ordering
... On 26.04.2007 16:31, DA Morgan wrote: ... select <blar> ... would not give the same results as same query with the columns in the ... It's so warm over here that my brain probably starts frying... ...
(comp.databases.oracle.misc)
group by clause ordering
... select <blar> ... would not give the same results as same query with the columns in the ... Ignoring ordering. ... I am thinking about null columns, duplicate rows min max, count ...
(comp.databases.oracle.misc)