Subject Re: [firebird-support] Search Limit
Author Lucas Franzen
Harry,

> Hi All!!
>
> I know this might be a stupid question but can anyone tell me what
> Firebird version of the MySQL 'LIMIT' is ????
>
> I have about 8000 records in my database and I only want to return
> about 10 - 50 of the records at a time, not all 8000 records!!!

select FIRST n [SKIP m] *|fields
from ...


Luc.