Re: select ... from (select ... from ... order by ...) doesn't work ?

From: <tomklaasen_at_my-deja.com>
Date: Wed, 15 Sep 1999 08:54:04 GMT
Message-ID: <7rnmr7$1lt$1@nnrp1.deja.com>

In article <w=fcN=FmlVwc06QOIGKS7mjGOA5h_at_4ax.com>, tkyte_at_us.oracle.com wrote:
> A copy of this was sent to "Harlin Setiadarma" <harlins_at_bigfoot.com>
> (if that email address didn't require changing)
> On Mon, 13 Sep 1999 07:30:24 +0700, you wrote:
>
> >Hi,
> >I've tried to :
> >
> >select t1.a, t2.b, t2.c
> >from t1, (select b,c from t4 order by b) t2
> >
> >and it give error message like syntax error ???
> >But if I remove 'order by b' clause, it works....?
> >
> >Is somebody know how to make it works without removing order by
clause ?
> >
> >Thanks in advance...
> >
> >
> >
>
> that syntax is supported in Oracle8i, release 8.1
>
> It is not supported in any prior release.

In this context: is there a way to execute a "top-N" query in oracle 8.0? In 8.1, you can do

select * from
(select column from table order by column) where rownum <=50

Anybody has any ideas ?

tia,

tomK

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 03:54:04 CDT