要素:公共列+聚合函数+条件函数+group by
窄表
错误查询
SELECT INDEXNUM,CASE WHEN KPI = '槽位' THEN OIDVAL end as '槽位' ,CASE WHEN KPI = '型号' THEN OIDVAL end as '型号' FROM cpunarrow GROUP BY INDEXNUM
测试
SELECT INDEXNUM,CASE WHEN KPI = '槽位' THEN OIDVAL end as '槽位' ,CASE WHEN KPI = '型号' THEN OIDVAL end as '型号' FROM cpunarrow
增加聚合函数
SELECT INDEXNUM,MAX(CASE WHEN KPI = '槽位' THEN OIDVAL end) as '槽位' ,MAX(CASE WHEN KPI = '型号' THEN OIDVAL end) as '型号' FROM cpunarrow GROUP BY INDEXNUM