select [组],
组下面的所有人=( SELECT [姓名] +','
FROM tabel_name AS b
WHERE b. [组] = a. [组]
FOR XML PATH('') ) ,
组下面所有人的工资 =( SELECT [工资] +','
FROM tabel_name AS c
WHERE c. [组] = a. [组]
FOR XML PATH('') ) ,
max(工资)-min(工资) as 工资差 from tabel_name as a
group by [组]