Hi,

Yes. With FIRST and SKIP or ROWS.

http://www.firebirdsql.org/refdocs/langrefupd20-select.html#langrefupd20-first-skip
http://www.firebirdsql.org/refdocs/langrefupd20-select.html#langrefupd20-select-rows

Gabor

Pasi Parkkinen írta:

> Hi,
>
> is it possible to restrict the amount of returned rows in your SELECT statement, where you for example wants to get the first 1000 records. On other DB products there are ways but I couldn't find one from Firebird...
>
> -Pasi