db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: LIMIT clause in select query
Date Fri, 26 Aug 2005 14:13:03 GMT
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.




Mime
View raw message