SQL GROUP BY合并字符串

发布时间:2018-10-18编辑:佚名阅读(1462)

事例:

SELECT BeginCity, EndCity, FanDian, [CangWei]=STUFF((SELECT '/'+[CangWei]
                                                     FROM Test1 t
                                                     WHERE t.BeginCity=Test1.BeginCity AND t.EndCity=Test1.EndCity AND t.FanDian=Test1.FanDian
                                                    FOR XML PATH('')), 1, 1, '')
FROM Test1
GROUP BY BeginCity, EndCity, FanDian;

  关键字:SQLgroup by字符串合并


鼓掌

0

正能量

0

0

呵呵

0


评论区