Re: How to use 'Top' in oracle?

[Quoted] [Quoted] select product_name from product order by price where rownum<=3 in 8i only. Otherwise you'll have to write a Pl/Sql block/proc with a cursor.
On Mon, 25 Sep 2000 17:54:38 +0800, "mhwang" <mhwang_at_sz.utl.com.hk> wrote:

>I want to get the first 3 products order by these prices.
>But i get an error when using : "Select top 3 product_name from product
>order by product_price".
>How can i do it ?
>
>Any suggestions are appriciated.
>Ming at 9.25
>
>
>
Received on Tue Sep 26 2000 - 01:58:00 CEST