sql语句（在线守候）

[moumouren]

怎样写结果集相减的sql语句

[thingsfly]

select * from tab minus
(select * from tab where rownum<10);

[xinpingf]

select * from table1 where rownum<=20
minus
select * from table1 where rownum<=10