DB에 아래와 같이 레벨 값이 들어 있어요.
1
2
...
1을 만나면 숫자가 증가시키는 방법을 알고 싶습니다.
1 1
2 1
1 2
2 2
1 3
2 3
1 4
2 4
고수님들 좀 부탁드립니다.
with tt as ( select 1 lv from dual union all select 2 lv from dual union all select 1 lv from dual union all select 2 lv from dual union all select 2 lv from dual union all select 2 lv from dual union all select 1 lv from dual union all select 2 lv from dual union all select 2 lv from dual union all select 1 lv from dual union all select 2 lv from dual union all select 2 lv from dual union all select 2 lv from dual ) select lv, sum(decode(lv,1,1,0)) over(order by rownum) ss from tt