Dynamic Range Selection 1,000 rows at a time
Hi Kirk,
You can handle this with mutliple queries to your database.
The syntax is database dependent.
In oracle you'd have
select * from mytable where rownum 1000 and rownum < 1000;
If you're using DB2 let me know - I'll get the exact syntax.
|