SQL仅在所有行均符合条件时选择行

SELECt MISC_IDFROM HOLDGROUP BY MISC_IDHAVINg MIN(READY) <> 0;

示例运行：

$ with HOLD (HOLD_ID, MISC_ID, RULE_ID, READY)as (values    (1,1,1,1),    (2,1,2,1),    (3,1,3,1),    (4,2,4,0),    (5,2,1,1))select MISC_IDfrom HOLDgroup by MISC_IDhaving min(READY) <> 0; misc_id---------       1(1 row)

修改查询以处理加入规则：

SELECt HOLD.*, RULE.*FROM HOLDINNER JOIN RULEON HOLD.RULE_ID = RULE.RULE_ID AND RULE.ENABLED = 0WHERe MISC_ID IN (    SELECt MISC_ID    FROM HOLD    GROUP BY MISC_ID    HAVINg MIN(READY) <> 0);