mysql - 返回 1 行而不是多行

Question

您好，我有一个查询，目前返回 4 行数据。

SELECT (case when a.duedate < '2016-04-26' and a.total_paid > 0 
        then  count(a.duedate)
        else 0 end) as paidWithDelay,
        (case when a.duedate < '2016-04-26' and a.total_paid = 0 
        then  count(a.duedate)
        else 0 end) as Overdue,
        (case when a.duedate > '2016-04-26' and a.total_paid > 0  
        then count(a.duedate)
        else 0 end) as paidOnTime,
        (case when a.duedate > '2016-04-26' and a.total_paid = 0  
        then  count(a.duedate)
        else 0 end) as waitingForPayment
        FROM payment_plan a
        where a.payor_orig_id = 611 and a.UPDATE_DT is null
        group by a.duedate;

如图所示。 基本上我想要的是只返回一行像这样paidWithDelay 2，过期 1，paidontime 0 和 waitingForPayment 1，我尝试写 sum front of case ，但没​​有成功。

Answer 1

    select sum(paidwithdelay)paidwithydelay,sum(overdue)overdue,sum(paidontime)paidontime,sum(waitingforpayment)waitingforpayment 
from (SELECT (case when a.duedate < '2016-04-26' and a.total_paid > 0 
            then  count(a.duedate)
            else 0 end) as paidWithDelay,
            (case when a.duedate < '2016-04-26' and a.total_paid = 0 
            then  count(a.duedate)
            else 0 end) as Overdue,
            (case when a.duedate > '2016-04-26' and a.total_paid > 0  
            then count(a.duedate)
            else 0 end) as paidOnTime,
            (case when a.duedate > '2016-04-26' and a.total_paid = 0  
            then  count(a.duedate)
            else 0 end) as waitingForPayment
            FROM payment_plan a
            where a.payor_orig_id = 611 and a.UPDATE_DT is null
            group by a.duedate)temp;