pivot 스타일로 디비데이터 가져오기 SELECT TEMP.OWNER AS OWNER ,TEMP.HR AS HR ,TEMP.ADMIN AS ADMIN ,TEMP.EMPLOYEE AS EMPLOYEE ,'' AS AVGR --평균을 구해주기 위한 공갈컬럼 FROM ( SELECT (SELECT ROUND( (SUM(RD.REPLY_DETAIL) /(SELECT COUNT(RD.ITEM_ID) FROM HR_ID_DIAGNS_REPLY_DETAIL RD , HR_ITEM_MST IM WHERE RD.DIAGNSRPT_ID='RPT01' AND RD.DIAGNSRPT_ID=IM.DIAGNSRPT_ID AND RD.ITEM_ID=IM.ITEM_ID AND RD.ACCEPT_SEQ_NO='20012753' AND RD.SEQ_NO='1' AND IM.. 더보기 이전 1 ··· 17 18 19 20 21 22 23 ··· 200 다음