该文演示了SQL中的基本表创建和数据插入，然后展示了如何使用UNION、UNIONALL、EXCEPT和INTERSECT操作符来合并、排除和找出两个表(#bbb和#ccc)之间的数据集差异与共性。最后，删除了这两个表。
CREATE TABLE #bbb ( id INT, name VARCHAR ( 20 ) )
insert into #bbb values(1,'aaaaaaaaaaaaa')
insert into #bbb values(1,'bbbbbbbbbbbbb')
insert into #bbb values(1,'ccccccccccccc')
insert into #bbb values(1,'ddddddddddddd')
SELECT * FROM #bbb
CREATE TABLE #ccc ( id INT, name VARCHAR ( 20 ) )
insert into #ccc values(1,'aaaaaaaaaaaaa')
insert into #ccc values(1,'bbbbbbbbbbbbb')
insert into #ccc values(1,'eeeeeeeeeeeee')
insert into #ccc values(1,'fffffffffffff')
select * from #ccc
-- 并集
select * from #bbb union select * from #ccc
select * from #ccc union select * from #bbb
-- 可重复并集
select * from #bbb union all select * from #ccc
select * from #ccc union all select * from #bbb
-- 差集
select * from #bbb except select * from #ccc
select * from #ccc except select * from #bbb
-- 交集
select * from #bbb intersect select * from #ccc
select * from #ccc intersect select * from #bbb
drop table #bbb
drop table #ccc
2606
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
