是不是先排序,然后取某段 例: select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<21 minus select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<11;
sql写错了,现在改正 select * from A where no<=nend minus select * from B where no<nstart
是不是先排序,然后取某段 例: select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<21 minus select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<11;
为什么“order by子句只有在8i或以上版本才能在子查询中使用”? order by子句是基本子句,在7.3.3上也可使用呀!
例:
select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<21
minus
select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<11;
select * from A where no<=nend minus select * from B where no<nstart
例:
select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<21
minus
select rownum,bbb,ccc from (select * from a1 order by bbb) where rownum<11;
order by子句是基本子句,在7.3.3上也可使用呀!