Re: Order by in a subquery

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 27 Feb 2004 12:04:26 +0100
Message-ID: <403f239f$0$24942$626a14ce@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 - 05:04:26 CST