Previous we were using Borland Interbase. On those
procedures/triggers, we have using "rows" on sql select statement
such as...

SELECT Mo, Opno FROM DyBdlClkTimeLog
WHERE Logdate = NEW.Logdate
AND EmpCompanyCode = NEW.EmpCompanyCode
AND EmployeeCode = NEW.EmployeeCode
AND SysAdjEndTime >= NEW.LostTimeEnd
ORDER BY SysAdjEndTime ROWS 1
(while the purpose is to select the first row of the record)

But after come to the Firebird, this statement occur with the error...

Invalid token.
SQL error code = -104.
Token unknown - line 31, char 32.
ROWS.

I'm wonder the "rows" doesn't work on firebird. Is that any method
instead of "rows" in firebird? Or the name is different in firebird.
Please kindly give me some ideas. Thank you very much!