agojego가 작년재고고요
작년대비를 구해야하는데 좀 알려주시면 감사하겠습니다.
SELECT '01' as idx , '대리점' as gubun ,B.CORG_TEAM , SUM(CASE WHEN C.CLS_YYMM = '200712' THEN C.AMT ELSE 0 END) AS agojego ,
SUM(CASE WHEN C.CLS_YYMM = '200801' THEN C.AMT ELSE 0 END) AS jego1
, SUM(CASE WHEN C.CLS_YYMM = '200802' THEN C.AMT ELSE 0 END) AS jego2
, SUM(CASE WHEN C.CLS_YYMM = '200803' THEN C.AMT ELSE 0 END) AS jego3
, SUM(CASE WHEN C.CLS_YYMM = '200804' THEN C.AMT ELSE 0 END) AS jego4
, SUM(CASE WHEN C.CLS_YYMM = '200805' THEN C.AMT ELSE 0 END) AS jego5
, SUM(CASE WHEN C.CLS_YYMM = '200806' THEN C.AMT ELSE 0 END) AS jego6
, SUM(CASE WHEN C.CLS_YYMM = '200807' THEN C.AMT ELSE 0 END) AS jego7
, SUM(CASE WHEN C.CLS_YYMM = '200808' THEN C.AMT ELSE 0 END) AS jego8
, SUM(CASE WHEN C.CLS_YYMM = '200809' THEN C.AMT ELSE 0 END) AS jego9
, SUM(CASE WHEN C.CLS_YYMM = '200810' THEN C.AMT ELSE 0 END) AS jego10
, SUM(CASE WHEN C.CLS_YYMM = '200811' THEN C.AMT ELSE 0 END) AS jego11
, SUM(CASE WHEN C.CLS_YYMM = '200812' THEN C.AMT ELSE 0 END) AS jego12
FROM WOASIS.TB_MO_CLS_DTL_INFO C
,HOUSING.TB_GU106_DETAIL B
WHERE C.CLS_YYMM BETWEEN '200712' AND '200812' AND SUBSTR(C.AGEN_CD, 0, 1) = 'C' AND SUBSTR(C.AGEN_CD, 2, 6)=B.CUST_CODE
GROUP BY B.CORG_TEAM
|