oracle中minus

[size=large]oracle中minus[/size]

两个关联表的符合条件记录的交集,是于union作用相反. 
例: 
select * from table where rownum<=20 
minus 
select *from table where rownum<=10