sql中如何合并两个特定的字段?答:1、创建模拟的数据表 create table GoodsCate(Mid int not null,Code varchar(10) not null,Name varchar(20) not null,)2、添加模拟数据 insert into GoodsCate(Mid,Code,Name) values(1,'6801','电子仪器')insert into GoodsCate(Mid,Code,Name) values(2,'6802','激光仪器')insert into G...
sqlserver 分组 拼接其他字段答:select 4,'麦大伟','麦2','5岁' Union select 6,'张思','张1','3岁'下面是合并:Select ID,FName,CName=Stuff((Select ','+CName From @t Where ID=T.ID For xml path('')),1,1,''),CAge=Stuff((Select ','+CAge From @t Where ID=T.ID For xml path('')),1,1,'...