This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / query结果来自几个表的join, 如何拿到中间一部分记录, 如: 第100 条到第150条.
-anno(pp);
2001-7-23
(#141822@0)
-
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)