Re: 'Order by' in a subquery
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 1 Mar 2004 12:17:31 -0000
Message-ID: <404329dc$0$10335$ed9e5944_at_reading.news.pipex.net>
Date: Mon, 1 Mar 2004 12:17:31 -0000
Message-ID: <404329dc$0$10335$ed9e5944_at_reading.news.pipex.net>
what version? order by in a subquery may not be available what error do you get.
-- Niall Litchfield Oracle DBA Audit Commission UK [Quoted] "bob" <bobo_at_yahoo.fr> wrote in message news:c1n5o7$tf3$1_at_s1.read.news.oleane.net...Received on Mon Mar 01 2004 - 13:17:31 CET
> 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
>
>