Re: Order By Problem

move the ORDER BY to the outer query.

"Shaojie Hu" <maichen_at_rols.com> wrote in message news:8605vb$hmn$1_at_bob.news.rcn.net...
> Hi, All:
>
> Oracle does not allow to use Order By clause in subquery, how
do I solve the
> problem?
> what I want is something like this:
>
> select * from (select x.*, rownum r from foo
> order by col1);
>
> Thanks.
>
>
Received on Mon Jan 17 2000 - 17:02:28 CST