--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>
> >Hi,
> >
> >I have tables in my Firebird database with over 100000 records with out primary key
> >(I have primary key made from 3 fields) and I can't read data between first and second
> >key because it is a large amount of data.
> >So is there any solution in firebird to read for example first 1000 rows, next 1000
> >rows, next...
>
> Don't know if I understood your question. Is the answer as simple as
>
> SELECT *
> FROM <table>
> ROWS :a to :a+999
>
> HTH,
> Set
>