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?