WITH t AS
(
SELECT 1 cd, 1 grp, '100' cond1, '1' cond2, '2' cond3 FROM dual
UNION ALL SELECT 2, 1, '200', '2', '3' FROM dual
UNION ALL SELECT 3, 1, '300', '3', '4' FROM dual
UNION ALL SELECT 4, 2, '100', '2', '1' FROM dual
UNION ALL SELECT 5, 2, '200', '2', '2' FROM dual
UNION ALL SELECT 6, 2, '300', '2', '3' FROM dual
UNION ALL SELECT 7, 3, '300', '2', '2' FROM dual
UNION ALL SELECT 8, 3, '300', '2', '3' FROM dual
UNION ALL SELECT 9, 3, '300', '2', '4' FROM dual
)
SELECT cd, grp, cond1, cond2, cond3
     , c1 조건1
     , c2 조건2
     , CASE WHEN SUM(c1+c2) OVER(PARTITION BY grp) > 0
            THEN 'OK' ELSE 'NG' END 결과1
     , CASE WHEN COUNT(DECODE(c1||c2, '01', 1)) OVER(PARTITION BY grp) > 0
            THEN 'OK' ELSE 'NG' END 결과2
  FROM (
        SELECT cd, grp, cond1, cond2, cond3
             , CASE WHEN cond1 IN ('100','200') AND cond2 IN ('1','3')
                    THEN 1 ELSE 0 END c1
             , CASE WHEN cond3 = '1' THEN 1 ELSE 0 END c2
          FROM t
        )
;

마농님 감사합니다.