Hi,

You could do this using the FIRST clause, in place of TOP.

SELECT FIRST N * FROM <table> ...

You could also use the SKIP clause.

For example, if you want the first 10 rows of the resultset, you could use

SELECT FIRST 10 * FROM ...

If you then need the next 10 records you could use

SELECT FIRST 10 SKIP 10 * FROM ...

I think this works on all the Firebird versions.

Hope it helps.

Horacio