透视结构表中的WHERE子句

你可以用 group by 和 having :

SELECT s.id
FROM SAMPLE s
WHERE (TAG_NAME = 10 AND VALUE = 77) OR
      (TAG_NAME = 11 AND VALUE = 80)
GROUP BY s.id
HAVING COUNT(DISTINCT TAG_NAME) = 2;

我不知道DB2,但在Oracle中可以这样做:

select *
from   demo
where  (tag_name, value) in ((10,77), (11,80));

当你说:

如果我喜欢下面的内容,它将尝试创建一个标签名 必须两者都是 10和11,而值必须同时为77和80

如果你把它改成或者它应该起作用。

SELECT 
    * .
FROM 
    SAMPLE
WHERE
    (TAG_NAME=10 AND VALUE=77)
    OR (TAG_NAME=11 AND VALUE=80)
    OR (TAG_NAME=x AND VALUE=y)