存储过程里的SQL分类汇总怎么写?答:MYSQL数据库 SELECT 产品,GROUP_CONCAT(零件),SUM(数量),SUM(金额) FROM (SELECT 'A' AS 产品,'A1' AS 零件,'10' AS 数量,'10' AS 金额UNION ALLSELECT 'A' AS 产品,'A2' AS 零件,'20' AS 数量,'20' AS 金额UNION ALLSELECT 'A' AS 产品,'A3' AS 零件,'10' AS 数量,'10' ...
sql2000/2005分类汇总答:select 类别=' '+类别,数量,金额,xh=1 from ddtjb union select 类别=' '+类别+'类小计',数量=sum(数量),金额=sum(金额),xh=2 from ddtjb group by 类别 union select 类别='统计',数量=sum(数量),金额=sum(金额),xh=3 from ddtjb ) as a order by 类别,xh 又帮你修改了一下...