如何获得列值逗号seperatedly包括ID

Z时代
2024-01-10
分类：问答

我在我的当前表有如何获得列值逗号seperatedly包括ID

id value 1 newyork 1 boston 1 dallas

我需要下面的输出

id value 1 newyork, boston, dallas

回答：

Declare @YourTable table(ID int,[value] varchar(50)) 
Insert Into @YourTable values 
(1,'newyork'), 
(1,'boston'), 
(1,'dallas') 
Select A.ID 
     ,Value = (Select Stuff((Select Distinct ',' +value From @YourTable Where ID=A.ID For XML Path ('')),1,1,'')) 
From (Select Distinct ID From @YourTable) A

返回要求

ID Value 1 boston,dallas,newyork

以上是如何获得列值逗号seperatedly包括ID 的全部内容，来源链接： utcz.com/qa/265042.html