Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help: SELECT FROM (subquery) ? Is it possible?
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,