SELECT FIRST 20 SKIP 20 * FROM myTable;
SELECT FIRST 20 SKIP 40 * FROM myTable;
SELECT FIRST 20 SKIP 60 * FROM myTable;

----- Original Message -----
From: "skotaylor" <scott@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, August 27, 2004 12:19 PM
Subject: [firebird-support] Display X number of records


|
| Hello,
|
| 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?
|
|
|
|
|
|
| Yahoo! Groups Links
|
|
|
|
|