mysql - 有没有办法包括所有案例的总和？

Question

给定的SQL:有没有办法把结果集的总数带进来？

SELECT 
    SUM(CASE
        WHEN status = 3 THEN 1
        ELSE 0
    END) AS Open,
    SUM(CASE
        WHEN status = 4 THEN 1
        ELSE 0
    END) AS Close
FROM
    Table1
WHERE
    id = 2;

结果:

Open,Close
5,5

期望的结果:

Open,Close,Total
5,5,10

Answer 1

只需添加另一个 case 语句

SELECT 
    SUM(CASE
        WHEN status = 3 THEN 1
        ELSE 0
    END) AS Open,
    SUM(CASE
        WHEN status = 4 THEN 1
        ELSE 0
    END) AS Close
    SUM(CASE
        WHEN status IN (3, 4) THEN 1
        ELSE 0
    END) AS Total
FROM
    Table1
WHERE
    id = 2;