Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 61316 invoked from network); 16 Mar 2005 15:28:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 16 Mar 2005 15:28:59 -0000 Received: (qmail 9140 invoked by uid 500); 16 Mar 2005 15:28:57 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 9115 invoked by uid 500); 16 Mar 2005 15:28:57 -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 Delivered-To: moderator for derby-dev@db.apache.org Received: (qmail 85787 invoked by uid 99); 16 Mar 2005 15:18:42 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of denials@gmail.com designates 64.233.170.198 as permitted sender) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=Z6zF/E3WyQ2XiA9HhRn0qElHvrowGyMl08/0qVXFcKFHcttLwrywJ8vrGT1idIt9wPD+JPrasrEboWFbptGCEmP0TwYRZb2muUhvyPY9Buw2P5hvuy7tWR0iyonlFcFuXN8PJezhW6LPYTECoy/w2zHi5+COhICmVZBuAok0IoI= Message-ID: Date: Wed, 16 Mar 2005 10:18:38 -0500 From: Dan Scott Reply-To: Dan Scott To: Derby Discussion Subject: Re: LIMIT with Select Statement Cc: Derby Development In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <000001c52a33$aa988c70$0a01a8c0@Devang> X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N On Wed, 16 Mar 2005 06:48:16 -0800, Mamta Satoor wrote: > On Wed, 16 Mar 2005 19:52:56 +0530, Devang > wrote: > > > > > > Hi > > > > > > > > Is it possible to use "LIMIT" keyword with select statement? > > > > Or is there any other alternative for the same? > > > > > > > > Thanx > > > > > > > > Devang > > > > > > > > > > Hi Devang, > > If you search for "Support for SQL Limit?" in the derby developer list > archive, you will find last set of discussion on the LIMIT keyword. > > Here is the url for "Support for SQL Limit?" > http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065 > > Mamta > Hmm. Rather than the suggestion from Jeremy Boynes to add LIMIT as a Derby feature, what about adding a more standard window function feature like ROW_NUMBER() OVER as described in http://troels.arvin.dk/db/rdbms/#select-limit ? Speaking of which, perhaps someone could offer the Derby equivalents to Troels' comparison of SQL dialects page... Dan