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_at_soap.pipex.net>
Date: Tue, 3 Oct 2000 15:34:40 +0100
Message-ID: <8rcqq0$lha$1_at_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 [Quoted] Audit Commission UK "Douglas Nichols" <dnichols_at_fhcrc.org> wrote in message news:39D56476.58D3714C_at_fhcrc.org...Received on Tue Oct 03 2000 - 16:34:40 CEST
> 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
>
>
>