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

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -