sql分组字段的处理

TIM截图20171218153907new.png TIM截图20171218153729.png

 ---------------- sql语句 -----------
select * into #222
from (
select '张三' as name,'河北' as [address],'10:00' as arrive_time
union all 
select '张三' as name,'河北2' as [address],'12:00' as arrive_time
union all 
select '李四' as name,'江西1' as [address],'12:00' as arrive_time
union all 
select '李四' as name,'江西2' as [address],'12:00' as arrive_time
) as a

select * from #222 

select name, 
      stuff((select','+ convert(varchar(200),address) from #222
            where name=v.name for xml   path('')),1,1,'') as newaddress,       
      max(arrive_time) as maxtime       from #222 v         group by name