34,590
社区成员
发帖
与我相关
我的任务
分享
;WITH C AS(
select 'A' COL,'' COL1,333 COL3 union all
select 'B','A',444 union all
select 'C','' ,44444 union all
select 'D','',999 union all
select 'D','C',9994
)
SELECT * FROM C where not exists(select 1 from c c2 where c.COL =c2.COL1 or c.COL1 =c2.COL)
结果和四楼一致
;WITH C AS(
select 'A' COL,'' COL1,333 COL3 union all
select 'B','A',444 union all
select 'C','' ,44444 union all
select 'D','',999 union all
select 'D','C',9994
)
SELECT *
FROM C
Where COL not in (Select Col1 From C)
And COL1 not in (Select Col From C)
COL COL1 COL3
---- ---- -----------
D 999
(1 row(s) affected)
SELECT *
FROM C
WHERE col <> col1