set @x_sum_px=@x_sum_zs;
select *,@x_sum_px:=(@x_sum_px-1) as sum_px,
(SELECT SUM(hsl) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as hsl_sum ,
(SELECT SUM(cjl) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as cjl_sum ,
(SELECT SUM(zdf) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as zdf_sum ,
(SELECT SUM(cjje) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as cjje_sum
from __TABLE__ order by id desc limit 370
最佳答案