SQL Server 语句—查交集INTERSECT并集UNOIN差集EXCEPT

lxy1039

已于 2024-09-06 16:12:42 修改

阅读量141

点赞数 2

分类专栏： sql server 文章标签：数据库 sql

于 2024-06-17 16:14:54 首次发布

本文链接：https://blog.csdn.net/u010899032/article/details/139747195

版权

sql server 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

并集

select Creator,CreateName,TempFlag,* from Dec_DeclHeader t1
WHERE GWT_YZ_LB.dbo.DocCode='11111111111' --数据库A
UNION --去除重复行
select Creator,CreateName,TempFlag,* from Dec_DeclHeader t1
WHERE GWT_YZ_LBD.dbo.t1.DocCode='2222222222' --数据库B

select Creator,CreateName,TempFlag,* from Dec_DeclHeader t1
WHERE GWT_YZ_LB.dbo.DocCode='11111111111' --数据库A
UNION ALL --不去除重复行
select Creator,CreateName,TempFlag,* from Dec_DeclHeader t1
WHERE GWT_YZ_LBD.dbo.t1.DocCode='2222222222' --数据库B

差集

SELECT LogisticsNo from Dec_EPWayBilldtl where PID='XXXX'
EXCEPT
SELECT LogisticsNo from Dec_EPDeparturedtl where pid=(SELECT id from Dec_EPDeparture where BillNo='XXXX')

交集

SELECT LogisticsNo from Dec_EPWayBilldtl where PID='XXXX'
INTERSECT
SELECT LogisticsNo from Dec_EPDeparturedtl where pid=(SELECT id from Dec_EPDeparture where BillNo='XXXX')