--- In firebird-support@yahoogroups.com, "mfyeung_home"
<mingyeung@s...> wrote:

>
>
> Can anyone tell me how to fetch the first 100 records in a select
> statement?

To get the first 100 records, use:

select first 100 * from

To get the second 100 records, skipping the first 100, use:

select first 100 skip 100 * from

HTH,

Dan.