A request from my friend.
hi Experts,
I have the following data in oracle 11g, 6 invoices with total received amount from customer. want to create invoice wise outstanding query like running total balance.
1 | 1 | 15/11/2018 | 7 | 11000 | 46050 |
2 | 2 | 16/11/2018 | 7 | 14850 | |
| 3 | 10 | 16/11/2018 | 7 | 7000 | |
| 4 | 11 | 16/11/2018 | 7 | 10200 | |
| 5 | 12 | 16/11/2018 | 7 | 3000 | |
| | | | | |
i need the following query, kindly guide.
1 | 1 | 15/11/2018 | 7 | 11000 | 46050 | 11000 |
2 | 2 | 16/11/2018 | 7 | 14850 | | 14850 |
| 3 | 10 | 16/11/2018 | 7 | 7000 | | 7000 |
| 4 | 11 | 16/11/2018 | 7 | 10200 | | 10200 |
| 5 | 12 | 16/11/2018 | 7 | 3000 | | 3000 |
I have the same question (0)