[Oracle] MODEL

 

SELECT YM, COL_AMT
  FROM (
		SELECT '201401' AS YM, 10000 AS AMT FROM DUAL UNION ALL
		SELECT '201402' AS YM, 20000 AS AMT FROM DUAL UNION ALL
		SELECT '201403' AS YM, 30000 AS AMT FROM DUAL UNION ALL
		SELECT '201404' AS YM, 40000 AS AMT FROM DUAL UNION ALL
		SELECT '201405' AS YM, 50000 AS AMT FROM DUAL
       )
 WHERE 1=1
 MODEL DIMENSION BY (YM)
       MEASURES (AMT, COL_AMT)
       RULES ( COL_AMT['SUM'] = SUM(COL_AMT) [YM BETWEEN '201401' AND '201406'] )
 ORDER BY YM DESC

 

바빠서 설명은 나중에...