Re: Order By Problem

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 Mon Jan 17 2000 - 18:49:02 CST