Re: Sorting in Oracle7.3

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 16 Jun 1998 20:25:01 GMT
Message-ID: <01bd9964$7110d5f0$0300a8c0@WORKSTATION>

Stephan Schaefer <stephan.schaefer_at_camline.com> wrote in article <3584E5D8.280F872D_at_camline.com>...
> > Group by can be 'mis-used'as a order by because it implicitly
orders
> > the data. Note that even if you want to sort only on FIELD1 you
still
> > have to include all other fields you select in the group by
clause.
> >
>
> Hi Gregory, Sjefke.
>
> this version drops doubled entries. To be sure to get all rows you
> can do:
>

This trick can also fail completely if you are using the Parallel Query Option. Received on Tue Jun 16 1998 - 15:25:01 CDT