SELECT
B.BillNumberId,
STUFF((SELECT DISTINCT ','+ DetailCode from BuyBill
WHERE B.BillNumberId=BillNumberId FOR xml path('')),1,1,'') AS DetailCode --品牌名称
FROM dbo.BuyBill B
GROUP BY BillNumberId
SQL 去重合并列值
最新推荐文章于 2024-08-01 17:04:58 发布