oracle交集,并集,差集
[sql]
create
table
test1
(
name
varchar
(10),
NN
varchar
(10)
);
insert
into
test1
values
(
"test"
,
"A"
);
insert
into
test1
values
(
"test1"
,
"B"
);
insert
into
test1
values
(
"test1"
,
"C"
);
insert
into
test1
values
(
"test1"
,
"D"
);
insert
into
test1
values
(
"test1"
,
"E"
);
create
table
test2
(
name
varchar
(10),
NN
varchar
(10)
);
insert
into
test2
values
(
"test"
,
"A"
);
insert
into
test2
values
(
"test2"
,
"B"
);
insert
into
test2
values
(
"test2"
,
"C"
);
insert
into
test2
values
声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。
- 上一篇:没有了
- 下一篇:没有了