Subject Re: [firebird-support] Display X number of records
Author Florian Hector
> I have a table with unknown amount of records, I can display the
> first 20 records with:
> SELECT FIRST 20 * FROM myTable;
>
> How can I display the next 20 and so on?

SELECT FIRST 20 SKIP 20 * FROM myTable;

Florian