Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 34765 invoked from network); 27 Nov 2006 09:25:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 27 Nov 2006 09:25:31 -0000 Received: (qmail 5798 invoked by uid 500); 27 Nov 2006 09:25:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 5771 invoked by uid 500); 27 Nov 2006 09:25:39 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 5760 invoked by uid 99); 27 Nov 2006 09:25:39 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Nov 2006 01:25:39 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.1.36] (HELO gmp-ea-fw-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Nov 2006 01:25:26 -0800 Received: from d1-emea-10.sun.com (d1-emea-10.sun.com [192.18.2.120]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id kAR9P442019411 for ; Mon, 27 Nov 2006 09:25:04 GMT Received: from conversion-daemon.d1-emea-10.sun.com by d1-emea-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0J9D00L01U2PIG00@d1-emea-10.sun.com> (original mail from Bernt.Johnsen@Sun.COM) for derby-user@db.apache.org; Mon, 27 Nov 2006 09:25:04 +0000 (GMT) Received: from localhost ([129.159.112.201]) by d1-emea-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0J9D00N2BU5R1ML8@d1-emea-10.sun.com> for derby-user@db.apache.org; Mon, 27 Nov 2006 09:25:04 +0000 (GMT) Date: Mon, 27 Nov 2006 10:25:02 +0100 From: "Bernt M. Johnsen" Subject: Re: Limiting select results In-reply-to: <20061125135323.186440@gmx.net> Sender: Bernt.Johnsen@Sun.COM To: Derby Discussion Message-id: <20061127092502.GA10942@atum01.norway.sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: multipart/signed; boundary=gKMricLos+KVdGMg; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-disposition: inline References: <20061125135323.186440@gmx.net> User-Agent: Mutt/1.5.10i X-Virus-Checked: Checked by ClamAV on apache.org --gKMricLos+KVdGMg Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable >>>>>>>>>>>> Charlie Babitt wrote (2006-11-25 14:53:23): > Hallo! >=20 > How can I limit the maximum rows that are returned in a select in apache = derby? select * from table LIMIT 10; (as it works in postgres) gives me a s= yntax error at 10.... >=20 > Any help would be great... What about statement.setMaxRows(10) >=20 > yours > charlie > --=20 > Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!=20 > Ideal f=FCr Modem und ISDN: http://www.gmx.net/de/go/smartsurfer --=20 Bernt Marius Johnsen, Database Technology Group,=20 Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway --gKMricLos+KVdGMg Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFaq7ulFBD9TXBAPARAjTdAKDX90vM5RG+fJgknKogqeXkEzDN9wCgyHQ3 CEE/Ufwvg+Bc8N6wDK6E3Zw= =ofeZ -----END PGP SIGNATURE----- --gKMricLos+KVdGMg--