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