查询获取所有记录，直到列的总和小于或等于一个值

SELECT slno, item, price FROM ( 
      SELECT *, SUM(price) OVER (ORDER BY slno) AS total_price FROM table 
) AS t WHERE total_price <= 10000;

是的，子查询在数据量大的时候确实很慢，维护对应索引。或者查询出数据，用代码处理数据

select *
from t,
     (select @sum := 0) as t1
where (@sum := @sum + price) <= 10000;

或者

select *
from t as t1
where (select sum(t2.price) from t as t2 where t2.slno <= t1.slno) <= 10000;

维护一个额外的字段，例如cumulative_sum