SQL Language (MOSC)

MOSC Banner

incremental balance for each item

edited Sep 2, 2019 7:14AM in SQL Language (MOSC) 1 commentAnswered ✓

ser     item_code   qty

1            1                100
2            1                -20

3            1                -40

4            1                30

5            2                50

6            2                80

7            2               -60

8            3                60

9            3               -50

i need the output

ser     item_code   qty              inc_bal

1            1                100           100

2            1                -20             80

3            1                -40             40

4            1                30              70

5            2                50              50

6            2                80              130

7            2               -60              70

8            3                60              60

9            3               -50              10

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center