一条sql实现字符串分组合并

本文章利用一条sql语句实现了将sql表某列多行合为一个值和字符串分组合并功能，有需要的同学可以参考一下下。

代码如下	复制代码
declare @t table (Id int, Value char(5)) insert into @t '1','09:01' union select '1','12:05' union select '2','08:04' union select '2','17:09' union select '3','99888' select * from @t select id,stuff((select ','+rtrim(value) from @t where id=a.id for xml path('') ),1,1,'') as [values] from (select distinct id from @t) a