This question (https://stackoverflow.com/q/72975669/15603477) is fun. DB fiddle link: https://dbfiddle.uk/?rdbms=postgres_14&fiddle=36d685ad463831877ae70361be2cfa3b
account size id name 100 1 John 200 2 Mary 300 3 Jane 400 4 Anne100 5 Mike 600 6 Joanne Then expected output: account group size id name 1 100 1 John 1 200 2 Mary 1 300 3 Jane 2 400 4 Anne2 100 5 Mike 3 600 6 Joanne Idea is fixed order by id then cumulative sum. if <=600 then grouped together using the same row_number. But I imagine this kind question has been solved many times. Current posted solution uses a recursive query, which is really hard for me. Is there any simple or more intuitive way to solve this kind of problem? I can write some customized aggregate function to aggregate stops at 600. I can get the following result, So what's the next step? +------+----+--------+---------------+-----------------+ | size | id | name | capped_at_600 | large_or_eq_600 | +------+----+--------+---------------+-----------------+ | 100 | 1 | John | 100 | f | | 200 | 2 | Mary | 300 | f | | 300 | 3 | Jane | 600 | t | | 400 | 4 | Anne | 400 | f | | 100 | 5 | Mike | 500 | f | | 600 | 6 | Joanne | 1100 | t | +------+----+--------+---------------+-----------------+ -- I recommend David Deutsch's <<The Beginning of Infinity>> Jian
