db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: first n rows
Date Mon, 23 Jan 2006 16:39:58 GMT
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
> 
> ********************************************************
> 


Mime
View raw message