34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM TABLE WHERE COL1 IN(1) AND COL2 IN(A)
UNION
SELECT * FROM TABLE WHERE COL1 IN(1) AND COL2 IN(B)
UNION
SELECT * FROM TABLE WHERE COL1 IN(2) AND COL2 IN(A)
UNION
SELECT * FROM TABLE WHERE COL1 IN(2) AND COL2 IN(B)
UNION
SELECT * FROM TABLE WHERE COL1 IN(3) AND COL2 IN(A)
UNION
SELECT * FROM TABLE WHERE COL1 IN(3) AND COL2 IN(B)
SELECT *
FROM TABLE
WHERE (COL1 = 1 AND COL2 = 'A') OR (COL1 =2 AND COL2 IN(A,B))