Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sorting in Oracle7.3

Re: Sorting in Oracle7.3

From: GHouck <hksys_at_teleport.com>
Date: Thu, 11 Jun 1998 06:59:47 GMT
Message-ID: <357F804B.ADC@teleport.com>


Sjefke wrote:
>
> Hi Gregory,
>
> Try something like:
>
> CREATE TABLE not_sorted (FIELD1, FIELD2)
> AS
> SELECT FIELD1, FIELD2
> FROM sorted
> GROUP BY FIELD1, FIELD2;
>
> 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.
>

[snip]

This could lose rows from the source table if the aggregated fields are not unique, since GROUP BY returns only the unique combinations of the specified columns.

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Thu Jun 11 1998 - 01:59:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US