[Sample] Pivot, multi pivot
SELECT REQ_NO , CENT_CD , SPCM_COL_DM , BLD_NM , ZIP_CD , ADDR , ADDR_DTL FROM ( ) PIVOT( MAX(ATTB_VAL) FOR ATTB_ID IN ( 'CENT_CD' AS HEL_CENT_CD , 'SPCM_COL_DM' AS SPCM_COL_DM , 'BLD_NM' AS BLD_EQMT_NM , 'ZIP_CD' AS PAT_ZIP_CD , 'ADDR' AS PAT_ADDR , 'ADDR_DTL' AS PAT_ADDR_DTL ) ) select * from t1 pivot xml ( sum(c3) for c2 in (any) ) ; select * from t1 pivot xml ( sum(c3) for c2 in (select dist..
2015. 7. 31.