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