MYSQL 选择;我无法弄清楚如何根据不同的列值排除行

MYSQL Select; I cannot figure out how to exclude rows based on a different column value

本文关键字：排除何根选择弄清楚 MYSQL | 更新日期: 2023-09-27

标识  值
100    1
101    1
102    1
102    0
103    1

我希望所选内容返回 id 的 100,101,103;也就是说，如果同一个 id 有两行，一行值=1，另一行值=0，我想排除它。

Select id From table Group By id Having count(*) = 1

可以使用having MySQL结构：

SELECT id, count(*) AS tehCount FROM table GROUP BY id HAVING tehCount = 1;

SELECT * FROM
table 
GROUP BY id
HAVING COUNT(*) = 1