34,838
社区成员




;WITH tb(A) AS (
select '2,5,6' UNION ALL
select '1,3' UNION ALL
select '6,8'
)
SELECT distinct t.A FROM (
SELECT *,CONVERT(XML,'<r><n>'+REPLACE(A,',','</n><n>')+'</n></r>') AS x FROM tb
) t CROSS APPLY (SELECT s.b.value('.','int') AS n FROM t.X.nodes('r/n')s(b)) u
WHERE u.n<3
/*
A
2,5,6
1,3
*/