你是oracle,还是mysql啊
追问sql server 2008
追答你试一下,下面这个,看行不行,这是mysql的
SET @EE='';
SELECT @EE:= CONCAT(@EE,
'SUM(IF(col2=\'',col2,'\'',',col3,0))AS',col2,',')
FROM (SELECT DISTINCT col2 FROM table_name) A;
SET @QQ=CONCAT('SELECT ifnull(col1,\'total\') AS columnA,',
LEFT(@EE,LENGTH(@EE)-1),
',SUM(col3) AS TOTAL FROM table_name GROUP BY col1 WITH ROLLUP');
PREPARE stmt2 FROM @QQ;
EXECUTE stmt2;
追问本人新手。。这个看不太懂啊~ 大哥有时间吗,能按照上面表 帮我下一个吗