将多行连接成一个字段 [英] Concatenate multiple rows into one field

问题描述

我有一个像图像(源)这样的三列的表，想编写一个查询，给出像图像(结果)这样的表

I have a table with three column like image (Source) and want to write a query that give a table like image (Result)

推荐答案

SELECT DISTINCT customer,
    stuff((
            SELECT ',' + cast(policy as varchar(10))
            FROM table1 b
            WHERE a.customerid = b.customerid
            FOR XML path('')
            ), 1, 1, '') [policies]
FROM table1 a

这篇关于将多行连接成一个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！