mysql - Fetch records with sum less then or equal to values in dataset

Question

This question is an extension of the question here Query to get all records until the sum of column less than or equal a value

For the table: items

slno	item	price
1	item1	1000
2	item2	2000
3	item3	3000
4	item4	4000
5	item5	5000
6	item6	6000

question from:https://stackoverflow.com/questions/66067122/fetch-records-with-sum-less-then-or-equal-to-values-in-dataset

Answer 1

Use a cumulative sum and then join:

select v.*, i.*
from (select i.*, sum(price) over (order by slno) as running_price
      from items i
     ) i join
     values v
     on i.running_price <= v.value
order by v.id, i.slno;