sql-server – SQL Server差异(与交叉相反)
发布时间:2021-01-15 06:17:15 所属栏目:MsSql教程 来源:网络整理
导读:寻找在SQL Server中设置“差异”的简单/可扩展方式,请参阅下文. 如果你无法从图片中看出我正在寻找那些不在交叉路口的东西. 我见过一种方法: select * from ( (select 'test1' as a,1 as b) union all (select 'test2' as a,2 as b union all select 'tes
寻找在SQL Server中设置“差异”的简单/可扩展方式,请参阅下文. 如果你无法从图片中看出我正在寻找那些不在交叉路口的东西. 我见过一种方法: select * from ( (select 'test1' as a,1 as b) union all (select 'test2' as a,2 as b union all select 'test1' as a,1 as b ) )un group by a,b having count(1)=1 但我担心如果我使用两个大集合会发生什么(我不会从select”常量语句中查询,我的查询将从实际表中提取.) 编辑: 可能解决方案 drop table #temp_a; drop table #temp_b; go select * into #temp_a from ( select 1 as num,'String' as two,'int'as three,'purple' as four union all select 2 as num,'dog' as two,'purple' as four union all select 3 as num,'cat' as four ) a select * into #temp_b from ( select 1 as num,'decimal'as three,'purple' as four union all select 2 as num,'purple' as four union all select 3 as num,'dog' as four ) b SELECT IsNull(a.num,b.num) A,IsNull(a.two,b.two) B,IsNull(a.three,b.three) C,IsNull(a.four,b.four) D FROM #temp_a a FULL OUTER JOIN #temp_b b ON (a.num=b.num AND a.two=b.two and a.three=b.three and a.four=b.four) WHERE (a.num is null or b.num is null ) 结果:
解决方法这样的事怎么样?SELECT A,B FROM Table1 EXCEPT SELECT A,B FROM Table2 UNION SELECT A,B FROM Table2 EXCEPT SELECT A,B FROM Table1 以下是FULL OUTER JOIN方法的示例(假设A在两个表中都不可为空) SELECT IsNull(Table1.A,Table2.A) a,IsNull(Table1.B,Table2.B) B FROM Table1 FULL OUTER JOIN Table2 ON (Table1.A=Table2.A AND Table1.B=Table2.B) WHERE Table1.A is null or Table2.A is null (编辑:云计算网_宿迁站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- 太平洋3.15金牌产品全推荐
- SQLSERVER数据库中的对象工具:dbForge SQL Decryptor2.1.1
- sql-server-2008 – 将数据库从SQL Server 2000复制到SQL S
- 红帽子推出首款面向发烧用户的Linux软件Federa
- sql-server – 为什么在列大小增加后创建索引需要更长的时间
- 微软Windows Server 2003遇数据迁移难题
- sql-server – sql server express localdb.msi离线安装程序
- 微软对Linux用户展开调查 知己知彼反击对手
- 通用分页存储过程真的有注入漏洞吗
- 使用Access SQL执行分组排名