> How to limit the number of registers returned from a query?
> In DB2 I use something like FETCH FIRST 10 ROWS ONLY

Please use Firebird-Support list for question about Firebird in general.

The short answer is SELECT FIRST 10 [SKIP n] col1, col2 FROM ...

Roman