Order by in subquery
From: Alayne McGregor <mcgregoa_at_cognos.COM>
Date: Wed, 14 Dec 1994 18:30:40 GMT
Message-ID: <1994Dec14.183040.18739_at_cognos.com>
Date: Wed, 14 Dec 1994 18:30:40 GMT
Message-ID: <1994Dec14.183040.18739_at_cognos.com>
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?
-- Alayne McGregor mcgregoa_at_cognos.comReceived on Wed Dec 14 1994 - 19:30:40 CET