SQL Server Concatenate String

原创于 2013-05-08 23:05:54 发布 · 391 阅读

CC 4.0 BY-SA版权

本文介绍了一种使用SQL声明表格并根据类别对电子邮件进行分组的方法。通过创建一个临时表格并插入唯一类别与对应的电子邮件，可以有效地管理和组织大量电子邮件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Suppose I got a table with emails and category and I want to group the emails based on category, the following sql statement can be simply be used:

DECLARE @Email AS TABLE
(
	Category INT,
	Email VARCHAR(MAX)
)


INSERT INTO @Email
SELECT DISTINCT te.Category,
(
	SELECT Email + ','
	FROM @TempEmail te2
	WHERE te2.Category = te.Category
	ORDER BY Email
	FOR XML PATH('')
) AS Email
FROM @TempEmail te