现有数据如下:
Sql:
select a.MODELID,
max( case a.PNAME when'计划开始' then a.PVALUE end) as RStart,
max( case a.PNAME when '计划结束' then a.PVALUE end) as Rend from TB_CONSTRUCTION_PROPERTY as a
group by a.MODELID
结果:
现有数据如下:
Sql:
select a.MODELID,
max( case a.PNAME when'计划开始' then a.PVALUE end) as RStart,
max( case a.PNAME when '计划结束' then a.PVALUE end) as Rend from TB_CONSTRUCTION_PROPERTY as a
group by a.MODELID
结果: