Re: Top clause
From: joel garry <joel-garry_at_home.com>
Date: Fri, 12 Apr 2013 09:12:43 -0700 (PDT)
Message-ID: <0d5d400b-6177-48a6-a3fb-3c89bd330738_at_oy9g2000pbb.googlegroups.com>
On Apr 12, 4:19 am, happy <ehabaziz2..._at_gmail.com> wrote:
> I can not find that statement works well in oracle 11 sql :
> select top 3 * from customers_5;
Date: Fri, 12 Apr 2013 09:12:43 -0700 (PDT)
Message-ID: <0d5d400b-6177-48a6-a3fb-3c89bd330738_at_oy9g2000pbb.googlegroups.com>
On Apr 12, 4:19 am, happy <ehabaziz2..._at_gmail.com> wrote:
> I can not find that statement works well in oracle 11 sql :
> select top 3 * from customers_5;
It helps to have an idea what you really want. Then you can google for it.
http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_select_the_TOP_N_rows_from_a_table.3F
jg
-- _at_home.com is bogus. http://www.forbes.com/sites/oracle/2013/04/12/oracles-software-on-silicon-10-reasons-itll-redefine-enterprise-computing/Received on Fri Apr 12 2013 - 18:12:43 CEST