问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏
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
评论
有用 0
墨值悬赏
