데이터베이스 질문과 답변
테이블
20200701 100 200 300 400
20200702 111 222 333 444
20200703 222 333 444 555
20200704 666 777 888 999
20200705 100 200 300 400
20200706 111 222 333 444
결과 예시 날짜을 1일 변환
20200701
--------------------
결과
100
200
300
400
by 마농
[2020.07.23 07:56:13]
WITH t AS
(
SELECT '20200701' dt, 100 v1, 200 v2, 300 v3, 400 v4 FROM dual
UNION ALL SELECT '20200702', 111, 222, 333, 444 FROM dual
UNION ALL SELECT '20200703', 222, 333, 444, 555 FROM dual
UNION ALL SELECT '20200704', 666, 777, 888, 999 FROM dual
UNION ALL SELECT '20200705', 100, 200, 300, 400 FROM dual
UNION ALL SELECT '20200706', 111, 222, 333, 444 FROM dual
)
SELECT *
FROM (SELECT dt
, v1, v2, v3, v4
FROM t
WHERE dt IN ('20200701', '20200702', '20200703')
)
UNPIVOT (v FOR gb IN (v1, v2, v3, v4))
PIVOT (MIN(v) FOR dt IN ('20200701', '20200702', '20200703'))
ORDER BY gb
;
) 버튼을 클릭하여 작성 하시면 됩니다.