From derby-dev-return-1068-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Sun Nov 28 04:38:23 2004 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 45299 invoked from network); 28 Nov 2004 04:38:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 28 Nov 2004 04:38:22 -0000 Received: (qmail 80496 invoked by uid 500); 28 Nov 2004 04:38:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 80470 invoked by uid 500); 28 Nov 2004 04:38:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 80456 invoked by uid 99); 28 Nov 2004 04:38:21 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from e4.ny.us.ibm.com (HELO e4.ny.us.ibm.com) (32.97.182.144) by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 27 Nov 2004 20:38:19 -0800 Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236]) by e4.ny.us.ibm.com (8.12.10/8.12.10) with ESMTP id iAS4cFEJ004243 for ; Sat, 27 Nov 2004 23:38:15 -0500 Received: from d01av01.pok.ibm.com (d01av01.pok.ibm.com [9.56.224.215]) by d01relay04.pok.ibm.com (8.12.10/NCO/VER6.6) with ESMTP id iAS4cF8S252596 for ; Sat, 27 Nov 2004 23:38:15 -0500 Received: from d01av01.pok.ibm.com (loopback [127.0.0.1]) by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id iAS4cFR4015187 for ; Sat, 27 Nov 2004 23:38:15 -0500 Received: from debrunners.com (sig-9-48-123-97.mts.ibm.com [9.48.123.97]) by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id iAS4cEet015180 for ; Sat, 27 Nov 2004 23:38:15 -0500 Message-ID: <41A95632.3010301@debrunners.com> Date: Sat, 27 Nov 2004 20:38:10 -0800 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4.1) Gecko/20031008 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: Re: Support for SQL Limit? References: <005801c4d4b6$f83166a0$6401a8c0@brianxp> In-Reply-To: <005801c4d4b6$f83166a0$6401a8c0@brianxp> X-Enigmail-Version: 0.76.8.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brian Abbott wrote: > As far as I can tell, Derby does not currently support the SQL Limit > command. Am I missing something? If it doesnt, are there any plans to > implement it? > Derby supports limiting the number of rows returned by a query through the standard JDBC java.sql.Statement.setMaxRows() method. Dan. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFBqVYOIv0S4qsbfuQRAiMsAKCgY/IdgMmBhMHVtrG40a9zVVnd4QCgnsBC 3ZLKFhckBzEC8dvZ8ZE97AA= =E96Z -----END PGP SIGNATURE-----