--- In firebird-support@yahoogroups.com, HBK <fotok@o...> wrote:

> Hi
>
> Best way of limiting returned number of rows ?
>
> Can "Where ROW_COUNT < 1000" be used to limit returned number of

records

> if query returns > 1000 ?
>
> Or are there better ways of doing this ?

SELECT FIRST 1000 fld FROM tbl ...

Emiliano