Yves,

If you download the Firebird v1.0 Beta2 release, you can use the new
FIRST and SKIP keywords.

Unlike mySQL, the FIRST keyword should appear right after the SELECT
keyword, as in:

SELECT FIRST X SKIP Y COLUMNNAME FROM TABLE ....


Sean