Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 24076 invoked from network); 26 Oct 2006 04:09:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Oct 2006 04:09:22 -0000 Received: (qmail 33168 invoked by uid 500); 25 Oct 2006 02:59:31 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 33145 invoked by uid 500); 25 Oct 2006 02:59:31 -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 33132 invoked by uid 99); 25 Oct 2006 02:59:31 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Oct 2006 19:59:31 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Oct 2006 19:59:17 -0700 Received: from [127.0.0.1] (bp-laptop.edgility.com [10.10.11.67]) by red.amberpoint.com (8.12.11/8.12.11) with ESMTP id k9P2wt4i007496 for ; Tue, 24 Oct 2006 19:58:56 -0700 (PDT) Message-ID: <453ED2EE.2030502@amberpoint.com> Date: Tue, 24 Oct 2006 19:58:54 -0700 From: Bryan Pendleton User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: Derby Discussion Subject: Re: limit in select References: <00fb01c6f7dd$2a23a510$8700a8c0@referentia.com> In-Reply-To: <00fb01c6f7dd$2a23a510$8700a8c0@referentia.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org > Is there a jira issue for adding a limit statement (to limit the number > of records returned) to a select statement? I did a jira search but > could find no such issue. I�d like to vote for it. Hi Jim, I think DERBY-581 is the issue that tracks this request: http://issues.apache.org/jira/browse/DERBY-581 Thanks for using Derby, and keep those good ideas coming! bryan