Kurt,
Try "select first 200 * from data order by date desc"
HTH
John

> -------Original Message-------
> From: federonline <federonline@...>
> Subject: [firebird-support] Firebird equivalant to "LIMIT"
> Sent: 15 Apr '07 08:57
>
> 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.
>
>