MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE products (
  id int ,
  price int  );


insert into products values 
(1,199),
(2,50),
(3,320),
(4,120);

Records: 4  Duplicates: 0  Warnings: 0


select * from products ;


id
price


1
199

2
50

3
320

4
120


SELECT id,
       price,
       SUM(price) OVER(ORDER BY id asc ) AS cumulative_sum
FROM products;


id
price
cumulative_sum


1
199
199

2
50
249

3
320
569

4
120
689


select id,
       price
from ( SELECT id,
              price,
              SUM(price) OVER(ORDER BY id asc ) AS cumulative_sum
       FROM products
     ) cum_sum
where cumulative_sum <=600;


id
price


1
199

2
50

3
320