Subject | Firebird equivalant to "LIMIT" |
---|---|
Author | federonline |
Post date | 2007-04-14T22:57Z |
Hi.
While migrating queries with a row limit, I noticed Firebird errors
with a unknown token error where "limit" occurs.
For example, "select * from data order by date desc limit 200" to pull
only the LAST 200 rows entered.
Is there a Firebird equivalent I can use to keep queries from
returning 10000 rows when I only need a few??
Thanks.
Kurt.
While migrating queries with a row limit, I noticed Firebird errors
with a unknown token error where "limit" occurs.
For example, "select * from data order by date desc limit 200" to pull
only the LAST 200 rows entered.
Is there a Firebird equivalent I can use to keep queries from
returning 10000 rows when I only need a few??
Thanks.
Kurt.