db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: LIMIT clause in select query
Date Fri, 26 Aug 2005 08:33:28 GMT
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.

 On 8/26/05, Amit Modi <amit_modi@persistent.co.in> 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

View raw message