Re: How to use 'Top' in oracle?
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 26 Sep 2000 11:04:08 +0100
Message-ID: <8qpsat$4j5$1_at_soap.pipex.net>
Date: Tue, 26 Sep 2000 11:04:08 +0100
Message-ID: <8qpsat$4j5$1_at_soap.pipex.net>
[Quoted] "NetComrade " <andreyNSPAM_at_bookexchange.net> wrote in message
news:37ed628d.26437414_at_news.earthlink.net...
> select product_name from product order by price where rownum<=3 in 8i
> only.
Does this mean that rownum has changed in 8i to work on the basis of rank. I [Quoted] [Quoted] must have missed that one if it did, and I kinda doubt it. Jonathon and basavaraj have given the two text book ways to achieve this.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Tue Sep 26 2000 - 12:04:08 CEST