Order by in a subquery

From: bob <bobo_at_yahoo.fr>
Date: Fri, 27 Feb 2004 11:24:37 +0100
Message-ID: <c1n5u8$tje$1@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 Received on Fri Feb 27 2004 - 04:24:37 CST