34,589
社区成员
发帖
与我相关
我的任务
分享
;WITH a(ID,c1,c2,c3) AS (
SELECT 1,10,20,30 UNION ALL
SELECT 2,20,39,40 UNION ALL
SELECT 3,30,43,55
),b(ID,c1,c2,c3) AS (
SELECT 1,11,20,33 UNION ALL
SELECT 2,25,39,42 UNION ALL
SELECT 3,30,43,55
)
SELECT c.* FROM a INNER JOIN b ON a.ID=b.ID
CROSS APPLY(VALUES('C1',a.c1,b.c1),('C2',a.c2,b.c2),('C3',a.c3,b.c3)) c(title,aCol,bCol)
WHERE c.aCol!=c.bCol
/*
比较结果,C2都相同
title aCol bCol
C1 10 11
C3 30 33
C1 20 25
C3 40 42
*/