with m as(
select *, row_number() over(partition by id order by id) rn
from t
)
select id,
max(case when rn = 1 then 客户 end) 客户1,
max(case when rn = 1 then 号码 end) 号码1,
max(case when rn = 2 then 客户 end) 客户2,
max(case when rn = 2 then 号码 end) 号码2
……
from m
select *, row_number() over(partition by id order by id) rn
from t
)
select id,
max(case when rn = 1 then 客户 end) 客户1,
max(case when rn = 1 then 号码 end) 号码1,
max(case when rn = 2 then 客户 end) 客户2,
max(case when rn = 2 then 号码 end) 号码2
……
from m
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货