Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 79716 invoked from network); 16 Sep 2006 09:50:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Sep 2006 09:50:50 -0000 Received: (qmail 58577 invoked by uid 500); 16 Sep 2006 09:50:49 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 58548 invoked by uid 500); 16 Sep 2006 09:50:49 -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 58537 invoked by uid 99); 16 Sep 2006 09:50:49 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [192.18.1.36] (HELO gmpea-pix-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Sep 2006 02:50:48 -0700 Received: from d1-emea-09.sun.com (d1-emea-09.sun.com [192.18.2.119] (may be forged)) by gmpea-pix-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k8G9oGUD014581 for ; Sat, 16 Sep 2006 10:50:16 +0100 (BST) Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J5O00901JA2TE00@d1-emea-09.sun.com> (original mail from Bernt.Johnsen@Sun.COM) for derby-user@db.apache.org; Sat, 16 Sep 2006 10:50:16 +0100 (BST) Received: from [10.0.0.7] ([80.203.115.180]) by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J5O0029LJBRDZFB@d1-emea-09.sun.com> for derby-user@db.apache.org; Sat, 16 Sep 2006 10:50:16 +0100 (BST) Date: Sat, 16 Sep 2006 13:50:11 +0200 From: "Bernt M. Johnsen" Subject: Re: Top 1 - Limit 1 In-reply-to: <450BC72F.1040000@informaticsmatters.com> Sender: Bernt.Johnsen@Sun.COM To: Derby Discussion Message-id: <450BE4F3.105@Sun.COM> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en X-Enigmail-Version: 0.93.0.0 References: <005701c6d864$b8c2ef30$6401a8c0@matkins> <450BC72F.1040000@informaticsmatters.com> User-Agent: Mozilla Thunderbird 1.0.8 (X11/20060725) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Tim Dudgeon wrote: > > > Marl Atkins wrote: > >> This would only work if the ID field is an Identity. >> As it happens, it IS so this should work for me too. >> >> THREE answers to my problem. >> You guys are good THANKS!! > > > Yes, but is there an equivalent to the TOP or LIMIT keywords that other > databases use? Not in SQL (neither in Derby nor the SQL standard). The closest equivalent is Statement.setMaxRows(i). > > Tim > -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway