一个 SQL 解决方案可实现历史应计项目、每月应计项目和每日细分项目

select biz_date,--业务日期
       cnt,--当日统计值
	   sum(cnt) over(order by biz_date asc) as cnt_all,--历史累计统计值
	   sum(cnt) over(partition by substr(biz_date,1,7) order by biz_date asc) as cnt_m--当月统计值
from tab
where pt='${bizdate}';