Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to use 'Top' in oracle?
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 Mon Sep 25 2000 - 18:58:00 CDT