列值分类转为列
2018-04-24 本文已影响0人
tommyhxh
SELECT DISTINCT bumen AS bumen,
SUM(CASE type
WHEN 'a' THEN num END) AS a,
SUM(CASE type
WHEN 'c' THEN num END) AS c,
SUM(CASE type
WHEN 'b' THEN num END) AS b FROM ttt GROUP BY bumen;
image.png
image.png
