我想在mysql查询中的某些条件下做SUM或SUBTRACTION。这是:SQLFiddle
健康)状况:
如果ce_type
是IN
OR,NULL
则添加payment_amount
一个变量
和
如果ce_type
是,OUT
那么我想payment_amount
从该变量中减去。
我用这个查询试过了。但是,我不知道如何在这里设置条件。
SELECT SUM(payment_amount) as payment_amount
FROM customer_payment_options
WHERE (real_account_id='11' AND real_account_type='HQ')
AND company_id='1'
如果我理解正确,那么您只需要条件聚合:
SELECT SUM(CASE WHEN ce_type = 'IN' or ce_type is NULL then payment_amount
WHEN ce_type = 'OUT' then - payment_amount
END) as payment_amount
FROM customer_payment_options
WHERE real_account_id = '11' AND real_account_type = 'HQ' AND company_id = '1';
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句