WITH T(gb, nm) AS ( SELECT 'A', '홍길동' FROM dual UNION ALL SELECT 'B', '홍길동' FROM dual UNION ALL SELECT 'A', '안중근' FROM dual UNION ALL SELECT 'A', '안중근' FROM dual UNION ALL SELECT 'A', '이순신' FROM dual UNION ALL SELECT 'B', '이순신' FROM dual ) SELECT gb, nm FROM ( SELECT gb, nm, COUNT(DISTINCT gb) OVER(PARTITION BY nm) cnt FROM T ) WHERE cnt = 1
답변감사합니다.
만약 구분 A,B가 있을때는 조회x
구분 A만 있을때 조회o
구분 A,C가 있을때 조회o <---추가
구분B가 있으면 조회x
할려면 어떻게 해야 할까요?
WITH T(gb, nm) AS (
SELECT 'A', '홍길동' FROM dual UNION ALL
SELECT 'B', '홍길동' FROM dual UNION ALL
SELECT 'A', '안중근' FROM dual UNION ALL
SELECT 'C', '안중근' FROM dual UNION ALL
SELECT 'A', '김유신' FROM dual UNION ALL
SELECT 'A', '김유신' FROM dual UNION ALL
SELECT 'A', '이순신' FROM dual UNION ALL
SELECT 'B', '이순신' FROM dual
)
SELECT gb, nm
FROM
(
SELECT gb, nm
FROM T
)