Re: How to use 'Top' in oracle?
From: Dirk Mika <dirk.mika.dm1_at_bayer-ag.de>
Date: Tue, 26 Sep 2000 12:49:44 +0200
Message-ID: <39D07F48.A347206E_at_bayer-ag.de>
Date: Tue, 26 Sep 2000 12:49:44 +0200
Message-ID: <39D07F48.A347206E_at_bayer-ag.de>
Hi,
[Quoted] 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.deReceived on Tue Sep 26 2000 - 12:49:44 CEST