我如何使用loanAmount 和amountPaid 來獲得余額。
SELECT (SELECT SUM(loanRepayment.amount) FROM `loanRepayment` WHERE loanRepayment.loanNumber='MMSE22062311' AND loanRepayment.transactionType ='DR')loanAmount,
(SELECT SUM(loanRepayment.amount) FROM `loanRepayment` WHERE loanRepayment.loanNumber='MMSE22062311' AND loanRepayment.transactionType ='CR')amountPaid,
(loanAmount-amountPaid)balance
uj5u.com熱心網友回復：
SELECT SUM(CASE WHEN transactionType = 'DR'
THEN amount
ELSE 0
END) loanAmount,
SUM(CASE WHEN transactionType = 'CR'
THEN amount
ELSE 0
END) amountPaid,
SUM(CASE WHEN transactionType = 'DR'
THEN amount
ELSE -amount
END) balance
FROM loanRepayment
WHERE loanNumber='MMSE22062311'
AND transactionType IN ('DR', 'CR')
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/497112.html
標籤：mysql
上一篇：描述每個表的列