PIVOT 사용시 IN 구분안에 서브쿼리를 사용 할 수 있는지 궁금합니다.
WITH T AS
(SELECT '2011' AS YEAR
, 1.1 AS VAL
FROM DUAL
UNION ALL
SELECT '2012' AS YEAR
, 1.2 AS VAL
FROM DUAL
UNION ALL
SELECT '2013' AS YEAR
, 1.3 AS VAL
FROM DUAL
UNION ALL
SELECT '2014' AS YEAR
, 1.4 AS VAL
FROM DUAL
UNION ALL
SELECT '2015' AS YEAR
, 1.5 AS VAL
FROM DUAL
)
SELECT *
FROM T
PIVOT(MIN(VAL) FOR YEAR IN ('2013','2014','2015'))
===> PIVOT(MIN(VAL) FOR YEAR IN (SELECT YEAR FROM T WHERE YEAR >= '2013'))
이렇게 사용 가능할까요?