Hi Mamta,
Thanks for the reply. I know about using the JDBC api
java.sql.Statement.setMaxRows() to limit
the number of rows returned, but the problem here is it returns the top
rows from the complete result.
But suppose I want 50 rows and that too from 51 to 100 from the complete
result, cannot be achieved using
setMaxRows().
So can you suggest some solution for this situation?
--
Regards:
Amit Modi
Mamta Satoor wrote:
Hi Amit,
There are couple threads on this issue. One of them can be found at
http://mail-archives.apache.org/mod_mbox/db-derby-user/200508.mbox/[EMAIL PROTECTED]
<http://mail-archives.apache.org/mod_mbox/db-derby-user/200508.mbox/[EMAIL PROTECTED]>
In short, Derby does not support LIMIT clause in the SELECT statement,
but alternatively, you can use JDBC api
java.sql.Statement.setMaxRows() to limit the number of rows returned.
Mamta
On 8/26/05, *Amit Modi* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
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
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:[EMAIL PROTECTED]
title:MTS
tel;work:0712 2226900 X: 409
tel;cell:09422881563
url:http://www.persistent.co.in
version:2.1
end:vcard
