날짜 주간 야간
20160701 25
20160703 0
20160705 0
20160706 0
20160707 25
20160711 4
20160715 0
위에서
번호 날짜 주간 야간
1 20160701 25
2 20160703 0
3 20160705 0
4 20160706 0
5 20160707 25
6 20160711 4
7 20160715 0
이렇게 추가하고싶습니다.
WITH A AS
(SELECT SHIFT,
SUMMARYDATE,
SUM(OUTCOUNT) AS OUTCOUNT
FROM PRODUCTIONSUMMARY
GROUP BY SHIFT,
SUMMARYDATE
)
SELECT *
FROM (
(SELECT A.SHIFT, A.SUMMARYDATE, A.OUTCOUNT FROM A
) PIVOT(SUM(OUTCOUNT) FOR SHIFT IN ('DAY' DAY, 'NIGHT' NIGHT)))
ORDER BY SUMMARYDATE;
쿼리는 이렇습니다.
WITH A AS (SELECT SHIFT, SUMMARYDATE, SUM(OUTCOUNT) AS OUTCOUNT FROM PRODUCTIONSUMMARY GROUP BY SHIFT, SUMMARYDATE ) SELECT ROWNUM AS RN , A.* FROM ( SELECT * FROM ( (SELECT A.SHIFT, A.SUMMARYDATE, A.OUTCOUNT FROM A ) PIVOT(SUM(OUTCOUNT) FOR SHIFT IN ('DAY' DAY, 'NIGHT' NIGHT))) ORDER BY SUMMARYDATE ) A ;