SELECT '1' AS COL1 ,NULL AS COL2 ,NULL AS COL3 FROM DUAL UNION ALL SELECT NULL AS COL1 ,'2' AS COL2 ,NULL AS COL3 FROM DUAL UNION ALL SELECT NULL AS COL1 ,NULL AS COL2 ,'3' AS COL3 FROM DUAL
WITH t AS ( SELECT '1' AS COL1, NULL AS COL2, NULL AS COL3 FROM DUAL UNION ALL SELECT NULL AS COL1,'2' AS COL2,NULL AS COL3 FROM DUAL UNION ALL SELECT NULL AS COL1,NULL AS COL2,'3' AS COL3 FROM DUAL) SELECT SUM(col1) AS col1, SUM(col2) AS col2, SUM(col3) AS col3 FROM t ;그럼 도움이 되셨길...
WITH T AS (SELECT '1' AS COL1 ,NULL AS COL2 ,NULL AS COL3 FROM DUAL UNION ALL SELECT NULL AS COL1 ,'2' AS COL2 ,NULL AS COL3 FROM DUAL UNION ALL SELECT NULL AS COL1 ,NULL AS COL2 ,'3' AS COL3 FROM DUAL ) SELECT MAX(DECODE(ROWNUM,1,COL1)) COL1, MAX(DECODE(ROWNUM,2,COL2)) COL2, MAX(DECODE(ROWNUM,3,COL3)) C0L3 FROM T