for oracle rowid
-macsym(日进斗斤);
2001-7-23(#141847@0)
If using ADO, you can complish that by setting AbsolutePage, PageSize... properties. For orcle, you can select rownum to get the records you want. The better way is to use stored procedures.
-oldgun(老枪);
2001-7-23(#142340@0)
How about "select TOP 150 * from table1 join table2 ..." and then go to the last record. Fetch the records one by one?
-tianqi21();
2001-7-24(#143365@0)
You should be able do it with minus and two subqueries.
in oracle:
select ... where rownum < 150
minus
select ... where rownum < 100
-sleepingchild(Sleeping Child);
2001-7-25(#144809@0)