sanjeev roy

sanjeev roy

  • 2k
  • 146
  • 4.1k

How to create debit / credit & Balance query in SQL

Jan 8 2023 6:20 AM

I need expected output



id          RefNo      TransDate  Dr                    Cr		Balance
----------- ---------- ---------- --------------------- ---------------------
            Opning balance						40
3           003        2013-01-03 300.00                0.00		340
4           004        2013-01-04 0.00                  100.00		240
5           004        2013-01-05 200.00                0.00		440

Best Regards 

Sanjeev


Answers (2)