您要使用 FOR XML PATH 构造：

select 
    ID, 
    stuff((select ', ' + Value 
           from YourTable t2 where t1.ID = t2.ID 
           for xml path('')),
          1,2,'') [Values]
from YourTable t1
group by ID

STUFF 函数是为了摆脱前导'，'。

The STUFF function is to get rid of the leading ', '.

您还可以看到另一个此处的示例：

You can also see another examples here:

• 两个表之间的SQL相同单位需要1个单元格中的订单号


• 剩下的SQL和Coldfusion联接表将重复的结果作为一列中的列表显示

• SQL same unit between two tables needs order numbers in 1 cell
• SQL and Coldfusion left join tables getting duplicate results as a list in one column