缴费金额按年排列

数据库：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;