行转列,sqlsever

请教一下sqlserver 行转列,感谢各位大佬

FineReport 用户k6280494 发布于 2022-7-22 11:58 （编辑于 2022-7-25 09:55）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

lxy2Lv6中级互助
发布于2022-7-22 13:44（编辑于 2022-7-22 14:28）

t20220722.rar

with a as (

select 5 as a,6 as b ,7 as c,8 as e ,'a1' as ttype

union all

select 12 as a,16 as b ,17 as c,18 as e ,'b1' as ttype

)

select ttype1,

score,

ttype

from a unpivot( score for ttype1 in (a,b,c,e))b

举报收起评论(5)

用户k6280494(提问者) 这样不行啊

2022-07-22 14:04

lxy2 回复用户k6280494(提问者) 你怎么写的，贴出来

2022-07-22 14:08

用户k6280494(提问者) 回复 lxy2 贴出来了,感谢

2022-07-22 14:10

lxy2 回复用户k6280494(提问者) 我试了是可以的啊，你把a换成你自己的数据集with a as( select 6 as sl1,7 as sl2,\'店铺数量\' as ttype union all select 26 as sl1,27 as sl2,\'店铺数量\' as ttype union all select 16 as sl1,71 as sl2,\'招牌长度\' as ttype union all select 60 as sl1,17 as sl2,\'招牌长度\' as ttype ) select * from a unpivot( score for ttype1 in (sl1,sl2))b

2022-07-22 14:26