这个是自学时的例子:
--测试表
create table test1
(
testid varchar2(20)
);
insert into test1 values('a001');
insert into test1 values('a002');
insert into test1 values('a003');
insert into test1 values('a004');
insert into test1 values('a005');
create table test2
(
testno varchar2(20)
);
insert into test2 values('a004');
insert into test2 values('a005');
insert into test2 values('a006');
insert into test2 values('a007');
insert into test2 values('a008');
insert into test2 values('a009');
-- 去重复后的集合
select testid from test1
union
select testno from test2;
结果是:
a001
a002
a003
a004
a005
a006
a007
a008
a009
-- 不去重复后的集合
select testid from test1
union all
select testno from test2;
结果是:
a001
a002
a003
a004
a005
a004
a005
a006
a007
a008
a009
-- 取交集
select testid from test1
intersect
select testno from test2;
结果是:
a004
a005
-- 取差集(如果不懂就到百度搜)
select testid from test1
minus
select testno from test2;
结果是:
a001
a002
a003