--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
wrote:

>
> >
> > So can I do
> > select * from ext_table from row 8000 to 16000?
> >
> > Regards,
> >
> > Robert
> >
>
> SELECT FIRST 8000 SKIP 8000 FROM ext_table
>
> Alan
>

As external tables can not be indexed, I would hesitate at taking such
an approach if the table is large. There is always a trade-off between
the speed of getting it done and the amount of feedback, but the select
first skip query without a supporting index will just get slower the
further down the list it gets.

Adam