Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Input Table
- AccountNO Serial Due Balance
- ---------- ----------- --------------------- ---------------------
- A1 1 1000.00 4100.00
- A1 2 1000.00 4100.00
- A1 3 1000.00 4100.00
- A1 4 2000.00 4100.00
- A2 1 100.00 4100.00
- A2 2 100.00 4100.00
- A3 1 500.00 4100.00
- B1 1 1000.00 1100.00
- B1 2 1000.00 1100.00
- B2 1 100.00 1100.00
- B2 2 100.00 1100.00
- Your Output :
- Serial AccountNO Due Balance r
- ----------- ---------- --------------------- --------------------- --------------------
- 3 A1 1000.00 4100.00 2
- 2 A1 1000.00 4100.00 3
- 1 A1 1000.00 4100.00 4
- 1 A2 100.00 4100.00 2
- 1 B1 1000.00 1100.00 2
- 1 B2 100.00 1100.00 2
- Required Output :
- AccountNO Serial Due Balance
- ---------- ----------- --------------------- ---------------------
- A1 1 1000.00 4100.00
- A1 2 1000.00 4100.00
- A1 3 1000.00 4100.00
- A2 1 100.00 4100.00
- A2 2 100.00 4100.00
- A3 1 500.00 4100.00
- B1 1 1000.00 1100.00
- B2 1 100.00 1100.00
Advertisement
Add Comment
Please, Sign In to add comment