请问一下这条SQL 能优化吗?

浏览:459 发布日期:2016/01/06 分类:求助交流
set @x_sum_zs=(SELECT id from __TABLE__ order by rq desc limit 1)+1;
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
最佳答案
评论( 相关
后面还有条评论,点击查看>>