minus用法:
A表 MINUS B表,
选择A表中不包含B表的内容;也就是选择:A表有的内容,而B表没有的内容;
表peng,和表peng2一模一样;
SQL> select count(*) from peng;
COUNT(*)
----------
10000
SQL> select count(*) from peng2;
COUNT(*)
----------
10000
SQL> select sheet_no,corpid ,depot_code from peng
2 minus
3 select sheet_no,corpid,depot_code from peng2
4 where rownum<=9990
5 ;
SHEET_NO CORPID DEPOT_CODE
-------------------- -------------------- --------------------
SL0000010442 XANDERCHINA3 SH
SL0000010443 XANDERCHINA3 SH
SL0000010445 XANDERCHINA3 SH
SL0000010446 XANDERCHINA3 SH
SL0000010447 XANDERCHINA3 SH
SL0000010448 XANDERCHINA3 SH
SL0000010449 XANDERCHINA3 SH
SL0000010450 XANDERCHINA3 SH
SL0000010451 XANDERCHINA3 SH
SL0000010452 XANDERCHINA3 SH
10 rows selected
10 rows selected
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22934571/viewspace-1042523/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22934571/viewspace-1042523/