Select Distinct [sid] From 表a Where()

------解决方案--------------------

SQL code

select distinct t1.sid from a t1
where exists (select 1 from a t2 where t2.sid=t1.sid and t2.cid=1000 and t2.intvalue<=3)
and exists (select 1 from a t3 where t3.sid=t1.sid and t3.cid=1001 and t3.stringvalue like '%,5,%')

------解决方案--------------------
SQL code

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'A')
BEGIN
    DROP TABLE A
END
GO
CREATE TABLE A
(
    sid INT,
    cid INT,
    stringvalue  VARCHAR(100),
    intvalue INT
)
INSERT INTO A
SELECT 1000, 1000, '',3 UNION
SELECT 1000, 1001, '0,2,5,12,', 0 UNION
SELECT 1000, 1002, '',3 UNION
SELECT 1001, 1000, '',4 UNION
SELECT 1001, 1001, '0,2,5,12,', 0 UNION
SELECT 1001, 1002, '',3 UNION
SELECT 1003, 1000, '',2 UNION
SELECT 1003, 1001, '0,1,4,5,7,13,', 0 UNION
SELECT 1003, 1002, '',2

SELECT sid FROM A
WHERE cid=1000 and intvalue<=3
INTERSECT
SELECT Sid FROM A
WHERE cid=1001 and stringvalue like '%,5,%'

sid
1000
1003

------解决方案--------------------
SQL code

--> 测试数据：[test]
if object_id('[test]') is not null drop table [test]
create table [test]([sid] int,[cid] int,[stringvalue] varchar(13),[intvalue] int)
insert [test]
select 1000,1000,'3',null union all
select 1000,1001,'0,2,5,12,',0 union all
select 1000,1002,'3',null union all
select 1003,1000,'2',null union all
select 1003,1001,'0,1,4,5,7,13,',0 union all
select 1003,1002,'2',null


--你的只需把 and 改成or即可
select * from test
where (cid=1000 and intvalue<=3) or
 (cid=1001 and stringvalue like '%,5,%')
/*
sid    cid    stringvalue    intvalue
1000    1001    0,2,5,12,    0
1003    1001    0,1,4,5,7,13,    0
*/