Sign in to follow this  
Followers 0
Riz

Simple SQL help

2 posts in this topic

#1 ·  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

Share this post


Link to post
Share on other sites



#2 ·  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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0