쿼리 보여주기 어려우면 원본 대비 결과표 보여주시면 됩니다.
그런데 원본이 없이 결과만 있네요?
원본 추측해서 답변 드립니다.
WITH t AS ( SELECT '20180401093319' reg_dt, '강정희' nm, '포도' cd, 13.10 v FROM dual UNION ALL SELECT '20180401093319', '강정희', '감' , 1.11 FROM dual UNION ALL SELECT '20180401093319', '강정희', '귤' , 30.20 FROM dual UNION ALL SELECT '20180401093323', '강정희', '사과', 10.90 FROM dual UNION ALL SELECT '20180401093323', '강정희', '배' , 250.00 FROM dual UNION ALL SELECT '20180401081235', '고중숙', '사과', 14.00 FROM dual UNION ALL SELECT '20180401081235', '고중숙', '배' , 91.00 FROM dual UNION ALL SELECT '20180401232716', '공필자', '포도', 11.50 FROM dual UNION ALL SELECT '20180401232716', '공필자', '감' , 0.97 FROM dual UNION ALL SELECT '20180401232716', '공필자', '귤' , 26.10 FROM dual UNION ALL SELECT '20180401232728', '공필자', '사과', 12.00 FROM dual ) SELECT reg_dt , nm , SUM(DECODE(cd, '사과', v)) 사과 , SUM(DECODE(cd, '배' , v)) 배 , SUM(DECODE(cd, '포도', v)) 포도 , SUM(DECODE(cd, '감' , v)) 감 , SUM(DECODE(cd, '귤' , v)) 귤 , SUM(DECODE(cd, '딸기', v)) 딸기 FROM t GROUP BY nm, reg_dt ORDER BY nm, reg_dt ;