mysql - Minus credit from debit column in same query? -
i have following query:
select user_id, sum( credit ) cred, sum( debit ) deb account user_id = '35'
i want minus debit credit , show in 1 column or value in variable
you can calculate difference in same line
select user_id, sum(credit) cred, sum(debit) deb, sum(credit) - sum(debit) total account user_id = 35 update 1
select user_id, sum(credit) cred, sum(debit) deb, sum(credit) - sum(debit) total account user_id in (30,31,32,33,34,35) group user_id update 2
select user_id, sum(credit) cred, sum(debit) deb, sum(credit) - sum(debit) total account user_id in (30,31,32,33,34,35) group user_id having (sum(credit) - sum(debit)) < 10
Comments
Post a Comment