Hi group,
I'm converting an app from MySQL to FB. One of the bothersome issues is syntax.
MySQL has the LIMIT modifier which takes a numeric argument, limiting the number of rows retuend by a query.
MSSQL has an equivalent in TOP. does Firebird have anything like this?
Obviously, one is inclined to think of the WHERE clause, but since you are not certain of what you're going to get back, until you've gotten it, it is not always possible to limit on the basis of the WHERE clause.
Any suggestions as to how to overcome this problem?
Regards,
Norman

[Non-text portions of this message have been removed]