Received: from office.knowledge.com (IDENT:exim@office.knowledge.com [195.40.167.196]) by hub.org (8.9.3/8.9.1) with ESMTP id KAA85999 for ; Thu, 29 Apr 1999 10:57:40 -0400 (EDT) (envelope-from mark@knowledge.com) Received: from mark (helo=localhost) by office.knowledge.com with local-esmtp (Exim 2.10 #1) id 10csFu-0002ls-00; Thu, 29 Apr 1999 15:57:38 +0100 Date: Thu, 29 Apr 1999 15:57:38 +0100 (BST) From: Mark Jewiss To: =?iso-8859-1?Q?Jos=E9?= Soares cc: Chris Bitmead , hackers Subject: Re: [SQL] LIMIT In-Reply-To: <372864D6.7FF6C7A0@sferacarta.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Mark Jewiss > I don't know nothing about ROWCOUNT. > SET ROWCOUNT doesn't work for me. > hygea=> set rowcount = 10; Sorry, this is my faul. Correct SQL syntax is set rowcount 10 Cheers, Mark.