项目当中经常统计12个月的数据;取到数据库最大的年月往前推12个月;
SELECT TO_CHAR(ADD_MONTHS(TO_DATE(to_char(to_date((select max(CALMONTH) as maxMonth
from JZSH_LSD_OPER_COST_MONTH),
'yyyy/mm')