Re: How to use 'Top' in oracle?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Oct 2000 15:34:40 +0100
Message-ID: <8rcqq0$lha$1@soap.pipex.net>

I didn't see the original post so your advice may be correct. However as of 8i order by is allowable in an inline view.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Douglas Nichols" <dnichols_at_fhcrc.org> wrote in message
news:39D56476.58D3714C_at_fhcrc.org...


> You cannot do the order by in the inner select.

>

> Dirk Mika wrote:

>

> > Hi,

> >

> > what about:

> >

> > select * from (select * from products order by price) where rownum <= 3;

> >

> > Dirk Mika

> > --

> > Bayer AG

> > WD-AED /LEV

> > D-51368 Leverkusen

> > Telefon: +49 (214) 30-50360

> > Telefax: +49 (214) 30-20031

> > Email  : dirk.mika.dm1_at_bayer-ag.de

>

> --

> Cheers, dn

>

> Douglas Nichols                              dnichols_at_fhcrc.org

> ---------------------------------------------------------------

> National Wilms Tumor Study Group                   206.667.4283

> Seattle, WA

>

>

>

Received on Tue Oct 03 2000 - 09:34:40 CDT