本文介绍了TSQL 比较两个集合的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当给出两组时
s1 ={ a,b,c,d} s2={b,c,d,a}
s1 ={ a,b,c,d} s2={b,c,d,a}
(即)
TableA Item a b c d TableB Item b c d a如何编写Sql查询以显示tableA和tableB中的元素相等".[不使用SP或UDF]
How to write Sql query to display "Elements in tableA and tableB are equal". [Without using SP or UDF]
输出
Elements in TableA and TableB contains identical sets 推荐答案使用:
SELECT CASE WHEN COUNT(*) = (SELECT COUNT(*) FROM a) AND COUNT(*) = (SELECT COUNT(*) FROM b) THEN 'Elements in TableA and TableB contains identical sets' ELSE 'TableA and TableB do NOT contain identical sets' END FROM (SELECT a.col FROM a INTERSECT SELECT b.col FROM b) x测试:
WITH a AS ( SELECT 'a' AS col UNION ALL SELECT 'b' UNION ALL SELECT 'c' UNION ALL SELECT 'd'), b AS ( SELECT 'b' AS col UNION ALL SELECT 'c' UNION ALL SELECT 'd' UNION ALL SELECT 'a') SELECT CASE WHEN COUNT(*) = (SELECT COUNT(*) FROM a) AND COUNT(*) = (SELECT COUNT(*) FROM b) THEN 'yes' ELSE 'no' END FROM (SELECT a.col FROM a INTERSECT SELECT b.col FROM b) x更多推荐
TSQL 比较两个集合
发布评论