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@soap.pipex.net>

"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 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 UK

Received on Tue Sep 26 2000 - 05:04:08 CDT