Re: group by clause ordering

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org