SQL把ID相同的记录合并成同⼀条记录SQL把ID相同的记录合并成同⼀条记录.需SQL 2005及以上.
Code
DECLARE@Table TABLE(id int, value varchar(10))
INSERT@Table SELECT1, 'AA'
UNION ALL SELECT1, 'BB'
UNION ALL SELECT2, 'AAA'
UNION ALL SELECT2, 'BBB'
UNION ALL SELECT2, 'CCC'
UNION ALL SELECT3, 'AAAA'
UNION ALL SELECT3, 'BBBB'
UNION ALL SELECT3, 'XXXX'
SELECT*FROM(
SELECT DISTINCT
id
FROM@Table
sql中union多表合并
) A
OUTER APPLY(
SELECT
[values]=STUFF(REPLACE(REPLACE(
(
SELECT value FROM@Table N
WHERE id = A.id
FOR XML AUTO
), '<N value="', ','), '"/>', ''), 1, 1, '')
) N

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。