Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!87.79.20.101.MISMATCH!newsreader4.netcologne.de!news.netcologne.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Top clause Date: Sat, 13 Apr 2013 23:20:28 +0000 (UTC) Organization: solani.org Lines: 26 Message-ID: References: <07118721-80c4-429b-b5ec-03100ef1caf6@c7g2000vbe.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1365895228 16064 eJwFwYEBwCAIA7CXBNoyz1GQ/09YwpCpEqLA4eAxslG9uXY5QmvAHLe362TelfpOS3YRhP8NoxBL (13 Apr 2013 23:20:28 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Sat, 13 Apr 2013 23:20:28 +0000 (UTC) User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) X-User-ID: eJwFwYEBACAEBMCVin9qHMT+I3RHtW3lMBo4nJLIdV/HpbinM2OkAtoz0GrBWd4bdZa+DP0xWhGz Cancel-Lock: sha1:60HrpYU57unGQD6ECVwiT3d5DsI= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXkLZ0nKNu/H/CEqFWXbNU1GigXPllJi8qTqlJh4jTW+aOHtjxGTHTz/sD7UsPtQ== Xref: news.cambrium.nl On Fri, 12 Apr 2013 17:20:09 -0300, prangel wrote: > You are evil :) > > grato. > > On 12/4/2013 16:13, Mladen Gogala wrote: >> 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. >> >> >> I'm a DBA, we're supposed to be evil. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com