db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Nielsen <Thomas.Niel...@Sun.COM>
Subject Re: limit
Date Thu, 11 Oct 2007 09:26:20 GMT
Hi Sudhakar,

Please note, as explained in DERBY-2998 and DERBY-581, that we are *not* 
implementing LIMIT (a dialect word), but rather following the SQL 
standard using the ROW_NUMBER() rank function.

There is still a way to go, and as Brian says if you're interested in 
helping we'd appreciate that a lot!


Bryan Pendleton wrote:
>> Everything I've read so far says that Derby does not implement LIMIT
>> which lets you write queries that return only so many rows in the 
>> resultset.
>> Is this still the case or has this changed? Or are there initiatives to
>> implement this? 
> DERBY-581 and DERBY-2998 are relevant, I believe.
> If you are interested in helping us work on this, there are lots of
> ways to help contribute to the effort, and we'd love to have more people 
> involved!
> thanks,
> bryan

Thomas Nielsen

View raw message