SELECT TYPE, SUM(CASE acct_month WHEN '200610' THEN charge ELSE NULL END) NY200610, SUM(CASE acct_month WHEN '200611' THEN charge ELSE NULL END) NY200610, SUM(CASE acct_month WHEN '200612' THEN charge ELSE NULL END) NY200610 FROM TEST123 GROUP BY TYPE;
SELECT TYPE, SUM(CASE acct_month WHEN '200610' THEN charge ELSE NULL END) NY200610, SUM(CASE acct_month WHEN '200611' THEN charge ELSE NULL END) NY200611, SUM(CASE acct_month WHEN '200612' THEN charge ELSE NULL END) NY200612 FROM TEST123 GROUP BY TYPE;
http://community.csdn.net/Expert/topic/5037/5037398.xml?temp=.2064173
SUM(CASE acct_month WHEN '200610' THEN charge ELSE NULL END) NY200610,
SUM(CASE acct_month WHEN '200611' THEN charge ELSE NULL END) NY200610,
SUM(CASE acct_month WHEN '200612' THEN charge ELSE NULL END) NY200610
FROM TEST123 GROUP BY TYPE;
SUM(CASE acct_month WHEN '200610' THEN charge ELSE NULL END) NY200610,
SUM(CASE acct_month WHEN '200611' THEN charge ELSE NULL END) NY200611,
SUM(CASE acct_month WHEN '200612' THEN charge ELSE NULL END) NY200612
FROM TEST123 GROUP BY TYPE;