oracle 统计当年和当月数据

		------年度
		select fa31.AFR042 AFR042,fa31.uus005 uus005,fa31.uus035 uus035,sum(fa31.afa007) afa007
         from fa31 fa31,fa06 fa06
        where fa31.afr041 = fa06.afr104
         and fa06.afr103 = '2'
         and afa080 >=
           TO_DATE(TO_CHAR(sysdate,'YYYY') || '01','YYYY-MM')
         and afa080 <=
           TO_DATE(TO_CHAR(sysdate,'YYYY') || '12','YYYY-MM')
        group by afr042,uus005,uus035

----月度
select fa31.AFR042 AFR042,sum(fa31.afa007) afa007
                  from fa31 fa31,fa06 fa06
                 where fa31.afr041 = fa06.afr104
                   and fa06.afr103 = '2'
              and afa080 = TO_DATE(TO_CHAR(sysdate,'YYYY-MM'),'YYYY-MM'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!