Re: Sorting in Oracle7.3

Thanks everyone for the suggestions. It is possible for me to group all the fields within my select statement because each record is unique.

Kind Regards,
Greg.

GHouck wrote in message <357F804B.ADC_at_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 - 05:05:08 CDT