WITH t(ts_ess_yn, ps_ess_yn, qs_ess_yn, pr_ess_yn) AS
(
SELECT 'Y', 'N', 'Y', 'N' FROM dual
)
SELECT *
FROM t
UNPIVOT (yn FOR cname IN (ts_ess_yn, ps_ess_yn, qs_ess_yn, pr_ess_yn))
WHERE yn = 'Y'
;
by 초짜
[2017.12.13 12:08:09]
감사합니다. ^^
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.