SELECT COL
FROM (
SELECT TEST1 AS COL FROM TBL UNION
SELECT TEST2 AS COL FROM TBL UNION
SELECT TEST3 AS COL FROM TBL UNION
SELECT TEST4 AS COL FROM TBL
)
WHERE COL IS NOT NULL
by 우리집아찌
[2016.12.22 13:52:40]
union 하면 group by 의미가 없지않나요??
by 개발뉴비
[2016.12.22 13:53:33]
크.. 그래서 잽싸게 수정했는데... 바로 걸렸네요..ㅎㅎ
by 마농
[2016.12.22 13:59:28]
WITH test AS
(
SELECT '001' test1, '002' test2, '' test3, '' test4 FROM dual
UNION ALL SELECT '001', '', '002', '' FROM dual
UNION ALL SELECT '002', '', '', '004' FROM dual
)
SELECT DISTINCT test0
FROM test
UNPIVOT (test0 FOR gb IN (test1, test2, test3, test4))
ORDER BY test0
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.