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
声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。
- 上一篇: Mybatis使用注解开发
- 下一篇: oracle中交集,并集,差集详解