Re: How to use 'Top' in oracle?

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