经过筛选之后的数据如下
http://114.80.245.132:8088/images/bbb.jpg
想再经过SQL筛选一下得到一下的效果
http://114.80.245.132:8088/images/ccc.jpg
帮帮忙
------解决方案--------------------------------------------------------
select name,一季度=isnull(sum(case quarter when '一季度' then real end),0),二季度=isnull(sum(case course when '二季度' then result end),0),三季度=isnull(sum(case course when '三季度' then result end),0),四季度季度=isnull(sum(case course when '四季度' then result end),0) from 表名 group by id order by gid