Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 68331 invoked from network); 26 Aug 2005 07:30:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 26 Aug 2005 07:30:07 -0000 Received: (qmail 91512 invoked by uid 500); 26 Aug 2005 07:30:07 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 91321 invoked by uid 500); 26 Aug 2005 07:30:05 -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 91227 invoked by uid 99); 26 Aug 2005 07:30:04 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Aug 2005 00:30:04 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [203.193.138.228] (HELO smtpnagpur.pspl.co.in) (203.193.138.228) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Aug 2005 00:30:17 -0700 Received: from [172.16.1.141] (proxynagpur.persistent.co.in [203.193.138.226]) (authenticated bits=0) by smtpnagpur.pspl.co.in (8.12.9/8.12.9) with ESMTP id j7Q7b0rm016886 for ; Fri, 26 Aug 2005 13:07:00 +0530 Message-ID: <430EC5C2.9070709@persistent.co.in> Date: Fri, 26 Aug 2005 13:03:22 +0530 From: Amit Modi Reply-To: amit_modi@persistent.co.in Organization: Persistent Systems User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: LIMIT clause in select query Content-Type: multipart/mixed; boundary="------------060803030607050707070804" X-Brightmail-Tracker: AAAAAQAAAAQ= X-White-List-Member: TRUE X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --------------060803030607050707070804 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, I want to use LIMIT clause in the select query, as I want specific number of rows, and the start point of the row can vary. So the LIMIT clause can work as there are two parameters in it, offset from where to start and number of rows. When i tried the same with derby, it was not working as derby does not support LIMIT. So is there anything equivalent in derby? -- Regards: Amit Modi --------------060803030607050707070804 Content-Type: text/x-vcard; charset=utf-8; name="amit_modi.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="amit_modi.vcf" begin:vcard fn:Amit Modi n:Modi;Amit org:PSPL, Nagpur adr:Second Floor, Infotech Tower;;Persistent Systems Pvt. Ltd.;Nagpur;Maharashtra;444203;India email;internet:amit_modi@persistent.co.in title:MTS tel;work:0712 2226900 X: 409 tel;cell:09422881563 url:http://www.persistent.co.in version:2.1 end:vcard --------------060803030607050707070804--