Db2 11.1

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

select service_level from sysibmadm.env_inst_info;


SERVICE_LEVEL


DB2 v11.1.4.4


create table t (
  salesid int,
  price decimal
)
insert into t
with dual as (
  select *
  from SYSIBM.SYSDUMMY1
)
select 1001 as salesid, 5 as price from dual union all
select 1002, 3 from dual union all
select 1003, 1 from dual union all
select 1004, 6 from dual union all
select 1005, 2 from dual
with a as (
  select
    t.*,
    sum(price) over(order by salesid asc) as price_rsum
  from t
)
select *
from a
where price_rsum <= 9


SALESID
PRICE
PRICE_RSUM


1001
5
5

1002
3
8

1003
1
9