SELECT
COALESCE ( SUM( CASE WHEN æ¥æ = ä¸å¨æ¥æå½æ° THEN å个åºå ELSE 0 END ), 0 ) AS ä¸å¨æ»åºå,
COALESCE ( SUM( CASE WHEN æ¥æ = æ¬å¨æ¥æå½æ° THEN å个åºå ELSE 0 END ), 0 ) AS æ¬å¨æ»åºå,
SUM(å个åºå) AS æ»åºå
FROM
åºå表
ç¨case then 大æ¦å°±è¿ææï¼å
·ä½çåæ°èªå·±ä¿®æ¹ä¿®æ¹å°±è¡äºã
温馨提示:答案为网友推荐,仅供参考