Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Order By Problem

Re: Order By Problem

From: Mohamed Buhari <mbuhari_at_assigncorp.com>
Date: 17 Jan 2000 19:49:02 EST
Message-ID: <3883B7FD.E25BFC5@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 Mon Jan 17 2000 - 18:49:02 CST

Original text of this message

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