Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT slno, item, price
- FROM
- (
- SELECT slno, item, price, @t := @t + price total
- FROM table1 CROSS JOIN (SELECT @t := 0) i
- ORDER BY slno
- ) q
- WHERE total <= 10000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement