Re: Top clause
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 12 Apr 2013 19:13:03 +0000 (UTC)
Message-ID: <pan.2013.04.12.19.13.03_at_gmail.com>
On Fri, 12 Apr 2013 04:19:06 -0700, happy wrote:
Date: Fri, 12 Apr 2013 19:13:03 +0000 (UTC)
Message-ID: <pan.2013.04.12.19.13.03_at_gmail.com>
On Fri, 12 Apr 2013 04:19:06 -0700, happy wrote:
> I can not find that statement works well in oracle 11 sql :
> select top 3 * from customers_5;
Your syntax is wrong. It should be "select 'top 3' from customers_5;". That will definitely work.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Fri Apr 12 2013 - 21:13:03 CEST