摘要: Oracle多表查询之minusselect * from A minus select * from B*****************************返回A表中A B不相同的部分。SQL> select * from test001; NAME ---------- 1 2 3 4 5 SQL> select * from test002; NAME ---------- 4 5 6 7 8 SQL> select * from test001 minus select * from test002; NAME ---------- 1 2 3 SQL> 阅读全文
posted @ 2011-09-05 14:57 KevinHuke 阅读(185) 评论(0) 推荐(0)