mysql 纵表转横表

表名：sales

SELECT
    NAME,
    sum(
        CASE MONTH
        WHEN '一月份' THEN
            money
        ELSE
            0
        END
    ) AS '一月份',
    sum(
        CASE MONTH
        WHEN '二月份' THEN
            money
        ELSE
            0
        END
    ) AS '二月份',
    sum(
        CASE MONTH
        WHEN '三月份' THEN
            money
        ELSE
            0
        END
    ) AS '三月份'
FROM
    sales
GROUP BY
    NAME;

结果：

 

转载于:https://www.cnblogs.com/cola-lxj/p/10528948.html