Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Mon, 23 Jan 2006 17:39:58 +0100
From: Kristian Waagan <Kristian.Waagan@Sun.COM>
Subject: Re: first n rows
In-reply-to: <200601231607.k0NG77EY007442@intranet.chand.mahindrabt.com>
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <43D506DE.5080507@Sun.com>
Organization: Sun Microsystems Inc.
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.7.12) Gecko/20050930
 Thunderbird/1.0.7 Mnenhy/0.7.2.0
References: <200601231607.k0NG77EY007442@intranet.chand.mahindrabt.com>

Binu Andrews wrote:
> hi,
> any one pls tell me how to fetch first or last n number of rows from a 
> derby table using SELECT clause

Hello,

As stated in the Derby FAQ (http://db.apache.org/derby/faq.html), Derby 
supports getting a limited number of rows through JDBC.
java.sql.Statement.setMaxRows();

When speaking of 'first' and 'last', I reckon you are referring to a an 
ordering determined by an ORDER BY clause.


hope this helps,
--
Kristian


>  
>  
> thanks in advance
>  
> Binu
> *********************************************************
> Disclaimer:
> The contents of this E-mail (including the contents of the enclosure(s) 
> or attachment(s) if any) are privileged and confidential material of MBT 
> and should not be disclosed to, used by or copied in any manner by 
> anyone other than the intended addressee(s). In case you are not the 
> desired addressee, you should delete this message and/or re-direct it to 
> the sender. The views expressed in this E-mail message (including the 
> enclosure(s) or attachment(s) if any) are those of the individual 
> sender, except where the sender expressly, and with authority, states 
> them to be the views of MBT.
> 
> This e-mail message including attachment/(s), if any, is believed to be 
> free of any virus. However, it is the responsibility of the recipient to 
> ensure that it is virus free and MBT is not responsible for any loss or 
> damage arising in any way from its use
> 
> ********************************************************
>