11 2021 档案

sql 多列转一列
摘要：SELECT name , value = ( STUFF(( SELECT ',' + value FROM A WHERE name = Test.name FOR XML PATH('') ), 1, 1, '') ) FROM A AS Test GROUP BY name; 阅读全文
posted @ 2021-11-26 10:10 魔法少女郭德纲啊 阅读(67) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示