Hi Amit,
There are couple threads on this issue. One of them can be found at
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
Mamta
On 8/26/05, Amit Modi <[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
