WITH TEMP AS (
SELECT 'CUSTOMER1' AS CUSTOMER, 'PART1' AS PART, 'A' AS FLAG, 1000 AS QTY1, 2000 AS QTY2, 3000 AS QTY3 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART1', 'B',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART1', 'C',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART1', 'D',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART1', 'E',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART2', 'A',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART2', 'B',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART2', 'C',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART2', 'D',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER1', 'PART2', 'E',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER2', 'PART3', 'A',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER2', 'PART3', 'B',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER2', 'PART3', 'C',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER2', 'PART3', 'D',1000,2000,3000 FROM DUAL UNION ALL
SELECT 'CUSTOMER2', 'PART3', 'E',1000,2000,3000 FROM DUAL
)
SELECT *
FROM TEMP

안녕하세요.

위와같은 TABLE 이 있을때 아래와 같이 조회 가능한지 문의 드립니다.

CUSTOMER 의 FLAG 별로 총합을 끼워 넣어야 하는데...

방법이 있을지 문의드립니다.ㅠ