Sql 语句实现累加,类似于
两列分别使用:col1 和 col2。
当col1=1, 结果为:251(col2中的第一个);
当col1=2, 结果为:251+182(col2中的第前两个相加);
当col1=3, 结果为:251+182+155(col2中的第前三个相加);
依次类推
select
(select SUM(sku_num_total) from user_redis_db_statis i
where i.sku_num_index<=user_redis_db_statis.sku_num_index
and DATEDIFF( create_time, CURDATE( ) ) =0
AND i.TYPE = 'pc_pin_browse')
from user_redis_db_statis
WHERE DATEDIFF( create_time, CURDATE( ) ) =0 AND TYPE = 'pc_pin_browse' order by sku_num_index