------------------字段的连接--------------------/*id1 id2 id3001 00101 20001 00101 80001 00101 75002 00101 20002 00101 10003 00101 70004 00101 70004 00101 70004 00101 70*/----->/*id1 id2 id3001 00101 20 80 75 002 00101 20 10003 00101 70 004 00101 70 70 70 */if object_id('getnum') is not nulldrop function getnumcreate function getnum(@id1 varchar(50))returns varchar(50)as begindeclare @sql varchar(50)set @sql=''select @sql=@sql+id3+' ' from c where id1=@id1set @sql=@sqlreturn @sqlend----select distinct id1,max(id2) id2,dbo.getnum(id1) as id3 from c group by id1,id3
