WITH T AS ( SELECT 2019 년도, 1 분기, 'I' 플래그, '10,000' 금액 FROM DUAL UNION ALL SELECT 2019, 2, 'I', '20,000' FROM DUAL UNION ALL SELECT 2019, 1, 'D', '10,000' FROM DUAL ) SELECT * FROM T WHERE (년도, 분기) NOT IN ( SELECT 년도 , 분기 FROM T WHERE 플래그 = 'D' ) ; WITH T AS ( SELECT 2019 년도, 1 분기, 'I' 플래그, '10,000' 금액 FROM DUAL UNION ALL SELECT 2019, 2, 'I', '20,000' FROM DUAL UNION ALL SELECT 2019, 1, 'D', '10,000' FROM DUAL ) SELECT * FROM T A WHERE NOT EXISTS ( SELECT 1 FROM T B WHERE A.년도 = B.년도 AND A.분기 = B.분기 AND 플래그 = 'D' ) ;