SELECT * FROM #T WHERE COL1 IN (SELECT COL1 FROM #T GROUP BY COL1 HAVING COUNT(1) = 1) AND COL2 IN (SELECT COL2 FROM #T GROUP BY COL2 HAVING COUNT(1) = 1)
select id, col1, col2 from (select id, col1, count(1) over(partition by col1 order by id) as cn1, col2, count(1) over(partition by col2 order by id) as cn2 from #t) where cn1 = 1 and cn2 = 1
FROM #T
WHERE COL1 IN (SELECT COL1 FROM #T GROUP BY COL1 HAVING COUNT(1) = 1)
AND COL2 IN (SELECT COL2 FROM #T GROUP BY COL2 HAVING COUNT(1) = 1)
select id, col1, col2
from (select id,
col1,
count(1) over(partition by col1 order by id) as cn1,
col2,
count(1) over(partition by col2 order by id) as cn2
from #t)
where cn1 = 1
and cn2 = 1