7,714
社区成员
发帖
与我相关
我的任务
分享
select 型号,
sum(if(级别='一级',数量,0)) as [一级],
sum(if(级别='二级',数量,0)) as [二级],
sum(if(级别='三级',数量,0)) as [三级],
sum(if(级别='特级',数量,0)) as [特级]
from Info
GROUP BY 型号
TRANSFORM Sum(数量) AS f3OfSum
SELECT 型号
FROM Info
GROUP BY 型号
PIVOT 级别;