此处示例按照日期,进行日期新增数据的累计求和;即:先统计每天的新增数据量,再统计每天的累计数据量
select a.*,@i:=@i+cnt as cnt_sum from (
select date_format(creation_date,"%Y-%m") c_date,count(*) cnt
from app_buy_pur_projects_all
where unit_id>0
group by c_date ) a,(select @i:=0) i_table
此处示例按照日期,进行日期新增数据的累计求和;即:先统计每天的新增数据量,再统计每天的累计数据量
select a.*,@i:=@i+cnt as cnt_sum from (
select date_format(creation_date,"%Y-%m") c_date,count(*) cnt
from app_buy_pur_projects_all
where unit_id>0
group by c_date ) a,(select @i:=0) i_table