如果是动态列的话, 就不能这样子做了..
select
单位名称,
sum(res.层级档) as 层级档,
sum(res.未脱困) as 未脱困,
sum(res.已脱困) as 已脱困,
sum(res.已注销) as 已注销,
sum(res.总计) as 总计
from
(
select
单位名称,
case when type = '层级档' then sum(字段) else 0 end as 层级档,
case when type = '未脱困' then sum(字段) else 0 end as 未脱困,
case when type = '已脱困' then sum(字段) else 0 end as 已脱困,
case when type = '已注销' then sum(字段) else 0 end as 已注销,
sum(字段) as 总计
from 表名
group by 单位名称
) res
group by 单位名称