select * from t1 where rownum<=150 order by col minus select * from t1 where rownum<100 order by col;
上面错了 SELECT * FROM (select * from t1 where rownum<=150 ORDER BY pk) MINUS SELECT * FROM (select * from t1 where rownum<100 ORDER BY pk) ;
select a.* from 表 a, (select rowid no from jbxx where rownum<151 group by rowid minus select rowid from jbxx where rownum<101 group by rowid) b where a.rowid=b.no
minus
select * from t1 where rownum<100 order by col;
SELECT * FROM (select * from t1 where rownum<=150 ORDER BY pk)
MINUS
SELECT * FROM (select * from t1 where rownum<100 ORDER BY pk) ;
(select rowid no from jbxx where rownum<151 group by rowid
minus
select rowid from jbxx where rownum<101 group by rowid) b where a.rowid=b.no
MINUS
SELECT * FROM (select * from t1 where rownum<100 ORDER BY pk) ;
谢谢各位。你们的语句在Oracle下是可以实现的,但是我现在想知道在interbase下如何实现?
IBsql1.SQL.Add("select...")
IBsql1->ExecQuery();
但查 79万100 ~~79万150条,我看以上的方法都不行了。
如果按oracle公司的介绍,这种情况必须用cursor,
既然如此,就不应该用一条标准sql了。