Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sorting in Oracle7.3
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