핸드폰이라 스크롤이 안되네요 ㅠㅠ. 고수분들의 도움이 필요합니다. 도와주세요

WITH tt AS
(
-- 정렬 기준이 반드시 필요한 문제입니다.
-- 정렬기준항목 seq 를 추가했습니다.
SELECT 1 id, 1 seq, 100 v FROM dual
UNION ALL SELECT 1, 2, 300 FROM dual
UNION ALL SELECT 1, 3, 500 FROM dual
UNION ALL SELECT 1, 4, 200 FROM dual
UNION ALL SELECT 1, 5, 300 FROM dual
UNION ALL SELECT 1, 6, 600 FROM dual
UNION ALL SELECT 1, 7, 150 FROM dual
)
, t1 AS
(
SELECT id, v
     , ROW_NUMBER() OVER(PARTITION BY id ORDER BY seq) rn
  FROM tt
)
, t2(id, rn, v, s, grp) AS
(
SELECT id, rn, v
     , v s
     , 1 grp
  FROM t1
 WHERE rn = 1
 UNION ALL
SELECT c.id, c.rn, c.v
     , CASE WHEN p.s >= 1000 THEN 0 ELSE p.s END + c.v s
     , CASE WHEN p.s >= 1000 THEN 1 ELSE 0 END + grp grp
  FROM t1 c
     , t2 p
 WHERE c.id = p.id
   AND c.rn = p.rn + 1
)
SELECT *
  FROM t2
;

 앗 마농님 감사합니다. 점심먹고 해볼께요

 감사합니다 잘대네요. 모르던 with절  사용법을 배워가네요

With t(a,b) as (
select 1, 100 from dual
union all select 1 , 300 from dual
union all select  1,  500 from dual
union all select 1 , 200 from dual
union all select 1 , 300 from dual
union all select 1 , 600 from dual
union all select 1 , 150 from dual
)select p.*, sum(b) over(partition by cgb order by rn) csum
from(select rn, a, b, cgb  from t
  model dimension by(row_number() over(order by rownum) rn)
    measures(a, b, 0 csum, 0 cgb)
    rules(csum[any] = case when csum[cv()-1]+b[cv()-1]>=1000 then 0 else nvl(csum[cv()-1] + b[cv()-1],0) end
          ,cgb[any] = case when csum[cv()-1]+b[cv()-1]>=1000 then cgb[cv()-1] + 1 else nvl(cgb[cv()-1],1) end)
) p