思路:
自连接,使用For XML Path('')和STUFF函数
SELECT * FROM STUDENT
Name Team
------------------------- -------------------------
Jack Team1
Rose Team1
Cindy Team1
Richard Team2
Jenny Team2
SELECT
T1.Team,
STUFF((
SELECT
CONCAT('/',T2.Name)
FROM
STUDENT T2
WHERE
T2.Team=T1.Team
FOR XML PATH('')
),1,1,'')
AS NAMES
FROM
STUDENT T1
GROUP BY
T1.Team
Team NAMES
------------------------- ---------------------------------------------------------
Team1 Jack/Rose/Cindy
Team2 Richard/Jenny