Re: Order by in a subquery

Thanks,

I found the reason of my problem. In fact, my query is not available for ORACLE 8.0.5, but available from the version 8i.

"Michel Cadot" <micadot{at}altern{dot}org> a écrit dans le message news: 403f239f$0$24942$626a14ce_at_news.free.fr...
>
> "bob" <bobo_at_yahoo.fr> a écrit dans le message de
news:c1n5u8$tje$1_at_s1.read.news.oleane.net...
> > Hello everyone,
> >
> > I have a problem with a query which looks like below
> >
> > SELECT r_num, T.Field1, T.Fiel2
> > FROM (
> > SELECT rownum as r_num,
> > Field1,Field2
> > FROM table1
> > order by field1
> > ) T
> > where r_num between 1 and 5
> >
> > I have a problem with the 'Order by' clause, but I need to sort the
records
> > in the subquery.
> >
> > So if anyone could help, it would be wonderful
> >
> > Thanks a lot
> >
> > Bob
> >
> >
>
> Go to Ask Tom site (http://asktom.oracle.com) and type "top n" in search
field.
>
> Regards
> Michel Cadot
>
>
Received on Fri Feb 27 2004 - 06:30:29 CST