This is DB2 syntax but it might work with Derby.. try select * from thetable fetch first 5 rows only
Regards, ~danesh On 8/10/05, Daniel Tripp <[EMAIL PROTECTED]> wrote: > > Hello. I'm trying to limit the number of rows returned by a select > statement. I know that other databases have way to do this, such as: > > select * top 10 from thetable > > set rowcount 5 > select * from thetable > > select * from thetable limit 10 > > But I gather that these are particular to MySQL / MS SQL / whatever. Done > anyone know of a way that this can be done with Derby? > >
