Jump to content

Recommended Posts

Posted (edited)

Hi all,

I have got table Trns like below, How can write SQL to find the balance?

date------desc---Credit---Debit---Balance

12/9------any 0.00 5.00 -500

13/9------any 3.00 0.00 -200

14/9------any 2.30 0.00 30

Thanks in advance.

Edited by Riz
Posted (edited)

Hi all,

I have got table Trns like below, How can write SQL to find the balance?

date------desc---Credit---Debit---Balance

12/9------any 0.00 5.00 -500

13/9------any 3.00 0.00 -200

14/9------any 2.30 0.00 30

Thanks in advance.

Any help please. its urgent :)

Edited by Riz

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...