Re: Order by in subquery
From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Tue, 20 Dec 1994 11:06:03 GMT
Message-ID: <James.Lawrence.69.000B1A30_at_epamail.epa.gov>
Date: Tue, 20 Dec 1994 11:06:03 GMT
Message-ID: <James.Lawrence.69.000B1A30_at_epamail.epa.gov>
In article <1994Dec14.183040.18739_at_cognos.com> mcgregoa_at_cognos.COM (Alayne McGregor) writes:
>From: mcgregoa_at_cognos.COM (Alayne McGregor)
>Subject: Order by in subquery
>Date: Wed, 14 Dec 1994 18:30:40 GMT
>In Oracle 7.0, it is not allowed to use an order by clause in a subquery.
>I would like to do this in conjunction with a select into in order to
>create a table with the result of this subquery (that contains the order by).
>Can someone suggest a workaround?
I'm missing something, why would you care about the order of the subquery set? The order won't change what is returned in the parent query.
Lawrence....
>--
>Alayne McGregor
>mcgregoa_at_cognos.com
Received on Tue Dec 20 1994 - 12:06:03 CET