We have two table having values as given below:
total_availablebalance of all the users with their names.
- CRE: credit, DEB: debit
- Result should be as given in below table.
Try at your end and see if you can get the similar result using your query. If you don't know the query then click here to see the answer.
If you have the better solution then kindly share with me on
firstname.lastname@example.org with post title as subject line, I will publish it here.
If you remember any MySQL query related quetion that you have been asked in any interview then kindly share it with me in
.txt file. So we can create a collection of MySQL query related interview questions that can help others to clear interview.