|
发表于 2021-4-28 20:49
来自手机
|
显示全部楼层
select 序号,姓名,sum(面积) 面积,group_concat(case when [40]='' then NULL else [40] end) as [40],group_concat(case when [50]='' then NULL else [50] end) as [50],group_concat(case when [60]='' then NULL else [60] end) as [60],group_concat(case when [80]='' then NULL else [80] end) as [80],group_concat(case when [100]='' then NULL else [100] end) as [100],group_concat(case when [120]='' then NULL else [120] end) as [120],group_concat(case when [140]='' then NULL else [140] end) as [140] from 姓名面积明细表 group by 姓名 order by 序号 |
|