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 -> Help: SELECT FROM (subquery) ? Is it possible?

Help: SELECT FROM (subquery) ? Is it possible?

From: Peder <peder.pedersen_at_fillmbyen.com>
Date: Thu, 20 Jan 2000 12:27:06 +0100
Message-ID: <866rcq$egf$1@news1.tele.dk>


Hey,

    I have a problem concerning subqueries and ORDER BY. I have a query which select a number of records and then does some ordering of them (using CONNECT BY). However, I want to ORDER the table the SELECT operates on, like this:

SELECT *
FROM (SELECT * FROM sometable ORDER BY something) WHERE ...
< connect by stuff >

instead of

SELECT *
FROM sometable
WHERE ....
< connect by stuff >

However, this doesn't seem to work. Why? Is there a way to do this. The problem I have that I can't order after the CONNECT BY, as this screws up the nice tree-like structure the CONNECT BY made.

Thanks in advance,

Received on Thu Jan 20 2000 - 05:27:06 CST

Original text of this message

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