SELECT
SUM(CASE sOutDev WHEN '部门1' THEN fcount ELSE 0 END) AS 部门1的出货数量,
SUM(CASE Quarter WHEN '部门2' THEN fcount ELSE 0 END) AS 部门2的出货数量,
SUM(CASE Quarter WHEN '部门3' THEN fcount ELSE 0 END) AS 部门3的出货数量
FROM 一个表
SUM(CASE sOutDev WHEN '部门1' THEN fcount ELSE 0 END) AS 部门1的出货数量,
SUM(CASE Quarter WHEN '部门2' THEN fcount ELSE 0 END) AS 部门2的出货数量,
SUM(CASE Quarter WHEN '部门3' THEN fcount ELSE 0 END) AS 部门3的出货数量
FROM 一个表
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货