数据库集合关联查找
0
所有回答(4)
0
应该可以用一个子查询实现
0
select * from test te where FIND_IN_SET((select myid from test where id='2'),te.myid) and id<>'2'; 看能不能给你提供一种思路。
0
子查询：
select ID from myTable where myID in(select myID from myTable where ID = 2)
0
SELECT *
FROM #temp t
WHERE not EXISTS
(
SELECT *
FROM
(
SELECT ',' + item + ',' AS item
FROM dbo.f_split(
(
SELECT TOP 1 myid FROM #temp WHERE id = 2
),
','
)
) a
WHERE CHARINDEX(a.item, ',' + t.myid + ',') <= 0
)
AND id !=2
