转化成
实现行转列sql语句如下:
select
*
from
(SELECT
t1.selling_level ,
t1.partner_name as pivotFiled
FROM cgs_deal_partner t1
where t1.deal_id = '22091610'
)
pivot(
max(pivotFiled) for selling_level in (
'1' as layer1,
'2' as layer2,
'3' as layer3,
'4' as layer4,
'5' as layer5
)
)