sqlserver 分组 拼接其他字段答:SQL2005或以上才可以:Declare @t Table (ID int,FName varchar(20),CName varchar(20),CAge varchar(20))Insert Into @t select 1,'吴亮','吴1','3岁' Union select 1,'吴亮','吴2','5岁' Union select 1,'吴亮','吴3','9岁' Union select 4,'麦大伟','麦1','3岁' Union ...