数据库:twt001
数据表:acaseyear
表内容如下:
相同的xm和sfzhm的只保留一条记录,按nyear在后面添加相应的年字段:
SELECT sfzhm,
SUM( CASE WHEN nyear = '2010' THEN
je ELSE 0 END)as y2010,
SUM( CASE WHEN nyear = '2011' THEN
je ELSE 0 END)as y2011,
SUM( CASE WHEN nyear = '2012' THEN
je ELSE 0 END)as y2012
FROM acaseyear
GROUP BY sfzhm;