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
********************************************************
