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?