SELECT
stuff(
(
SELECT
',' + a.要展示的字段
FROM
the_table a
WHERE
a.字段 = temp.字段
FOR xml path ('')
),
1,
1,
''
) AS 列名
FROM the_table temp
GROUP BY temp.分组字段
SELECT
stuff(
(
SELECT
',' + a.要展示的字段
FROM
the_table a
WHERE
a.字段 = temp.字段
FOR xml path ('')
),
1,
1,
''
) AS 列名
FROM the_table temp
GROUP BY temp.分组字段