DISTINCT在合并结果之前，请在子查询中使用关键字删除重复项：SQL
Fiddle
SELECt ProjectID,STRING_AGG(value, ',') WITHIN GROUP (ORDER BY value) AS NewFieldfrom ( select distinct ProjectId, newId.value FROM [dbo].[Data] WITH(NOLOCK) CROSS APPLY STRING_SPLIT([bID],';') AS newID WHERe newID.value IN ( 'O95833' , 'Q96NY7-2' ) ) xGROUP BY ProjectIDORDER BY ProjectID
