Question

存储过程里的SQL分类汇总怎么写？

请教各位大侠，第一张图里物料A、B、C，怎么写sql汇总成图二那样





Answer 1

MYSQL数据库

SELECT 产品,GROUP_CONCAT(零件),SUM(数量),SUM(金额) FROM (

SELECT 'A' AS 产品,'A1' AS 零件,'10' AS 数量,'10' AS 金额
UNION ALL
SELECT 'A' AS 产品,'A2' AS 零件,'20' AS 数量,'20' AS 金额
UNION ALL
SELECT 'A' AS 产品,'A3' AS 零件,'10' AS 数量,'10' AS 金额
UNION ALL
SELECT 'B' AS 产品,'B1' AS 零件,'10' AS 数量,'10' AS 金额
UNION ALL
SELECT 'B' AS 产品,'B2' AS 零件,'20' AS 数量,'20' AS 金额
UNION ALL
SELECT 'B' AS 产品,'B3' AS 零件,'10' AS 数量,'10' AS 金额

) T  GROUP BY 产品

Answer 2

select 产品,sum(isnull(数量,0)) as 数量,sum(isnull(金额,0)) as 金额 from 数据表 group by 产品