Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to use 'Top' in oracle?

Re: How to use 'Top' in oracle?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 25 Sep 2000 23:58:00 GMT
Message-ID: <37ed628d.26437414@news.earthlink.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US