db-derby-user mailing list archives

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?