It dose not work, but thanks anyway.
Mohamed Buhari <mbuhari_at_assigncorp.com> wrote in message
news:3883B7FD.E25BFC5_at_assigncorp.com...
> Here U go :-)
>
> 1. U cant user '*' in this type of query, so u need to specify each column
name
> explicitly.Here is an example
>
> select alias.x, alias.y, alias.z from
> (select x,y,z from xyz
> group by x,
> order by y ) alias;
>
> Mohamed
>
> Shaojie Hu wrote:
>
> > 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 Tue Jan 18 2000 - 10:05:05 CST
