Re: retrieving data from the table in chunks for paging
If the table is not fragmented then use the hidded "rowid" column.
select * from invoice where rowid between 0 and 100;
If the table has fragments you might be lucky in that it was created
"with rowids".
L.S.
↪ replying to LIGHT SCANS
On Mar 28, 9:28 am, LIGHT SCANS <light_sc...@yahoo.com> wrote:
> If the table is not fragmented then use the hidded "rowid" column.
>
> select * from invoice where rowid between 0 and 100;>
> If the table has fragments you might be lucky in that it was created
> "with rowids".
>
> L.S.
Be careful rowid's aren't contiguous