我正在尝试运行如下查询:
SELECT (SUM(amount) - SUM(refundAmount)) as amount FROM orders WHERE $invoiceFilter AND $websiteFilter
它正确地获得了“金额”列的总和,但没有减去退款金额。
这样的查询的正确语法是什么?
最佳答案
尝试这个:
SELECT SUM(amount - refundAmount) AS `amount`
FROM orders
WHERE
invoice = $invoiceFilter
AND website = $websiteFilter;
关于php - PHP MySQL选择一个SUM减去一个SUM,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/42287575/