with cte as
(
select 1 as id,'aaa' as v union all
select 2 as id,'bbb' as v union all
select 3 as id,'ccc' as v
)
select max(case when id = 1 then v else '' end)  as id1,max(case when id = 2 then v else '' end) as id2,max(case when id = 3 then v  else '' end)  as id3
from cte


复制

id1 id2 id3
aaa bbb ccc