mySQL COALESCE 过滤

Question

大家好，Stackoverflowers!我有一个正在处理的查询，我需要过滤掉 0，但它没有删除那些记录，我似乎无法弄清楚原因。

请看下面，

SELECT  disb_sum, pl_balance,
      COALESCE(p.pl_balance - pd.disb_sum, p.pl_balance - 0) AS pledge_balance
FROM      contacts c
LEFT JOIN pledges p ON c.c_no = p.c_no
LEFT JOIN (
        SELECT   pl_no, disb_status, disb_no, disb_amount, SUM(disb_amount) AS disb_sum
        FROM     disbursements
        WHERE disb_status = 1
        GROUP BY pl_no
        ) pd ON p.pl_no = pd.pl_no
GROUP BY p.pl_no
HAVING pledge_balance > "0"
ORDER BY  c.c_last

输出

# disb_sum, pl_balance, pledge_balance
NULL, '5000.00', '5000.00'
NULL, '5000.00', '5000.00'
'25000.00', '25000.00', '0.00'
NULL, '100000.00', '100000.00'
NULL, '6000.00', '6000.00'
NULL, '2500.00', '2500.00'
NULL, '1500.00', '1500.00'

我尝试添加一个额外的参数和 disb_sum <> disb_sum 但得到相同的结果集。

Answer 1

如果 Niloct 的回答不起作用，请尝试:

HAVING pledge_balance <> "0"