Hi Harry!

I don't know MySQL, but I guess it could be the equivalent of the

SELECT [FIRST] <number> [SKIP] <number> ...

i.e.

SELECT FIRST 10 * FROM ...

to get the first ten records and then

SELECT FIRST 10 SKIP 10 * FROM ...

to get the next 10.

HTH,
Set

--- In firebird-support@yahoogroups.com, "draconian2800" wrote:
> 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!!!
>
> Thanks for your help in this regard!!
>
> Harry Roets!!