MySQL:如何从表中检索具有重复值且满足多个条件的条目?

Question

假设我有以下表格…

<表类> id 价值 tbody><<tr>171819262727383838474949

这种类型的查询在这里经常出现。一种方法使用聚合:

SELECT id
FROM table_name
WHERE value in (7, 9)
GROUP BY id
HAVING COUNT(DISTINCT value) = 2;

GROUP BY和HAVING子句可以更好地解决这个问题:

SELECT id
FROM t
WHERE value IN (7, 9)
GROUP BY id
HAVING COUNT(DISTINCT value) = 2