db-derby-user mailing list archives

Amit Modi 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?
> 

See FAQ 3.2.

http://db.apache.org/derby/faq.html

Dan.