创建表和插入数据不再赘述
select ID, max(case temp.rownumber when 1 then temp.Code end) as code1, min(case temp.rownumber when 2 then temp.Code end) as Code2 , min(case temp.rownumber when 3 then temp.Code end) as Code3, max(case temp.rownumber when 1 then temp.Value end) as value1, min(case temp.rownumber when 2 then temp.Value end) as value2, min(case temp.rownumber when 3 then temp.Value end) as value3 from ( select ID, Code , Value, ROW_NUMBER() over(partition by id order by value) as rownumber from TableA ) as temp group by ID
最新评论