| AID | BID | STATE | |
|---|---|---|---|
| 1 | 1 | 1 | |
| 1 | 2 | 3 | |
| 1 | 3 | 3 | |
| 2 | 1 | 0 | |
| 2 | 2 | 3 | |
| 2 | 3 | 3 | |
| 3 | 1 | 3 | |
| 3 | 2 | 0 | |
| 3 | 3 | 3 |
如果您想查找所有没有0状态记录的AID，可以使用
SELECT
AID
FROM
mytable
GROUP BY
AID
HAVING
COUNT(
CASE WHEN STATE=0 THEN 1 END
)=0;
| AID |
|---|
| 1 |