SQL分组查询

https://www.cnblogs.com/friday69/p/9389720.html Sql Server中实现Mysql中的group_concat函数效果 SELECT stuff((select ',' + PUD_Dept from PB_User_Dept t where PUD_User = PUB_ID for xml path('')) , 1 , 1 , '') FROM [dbo].[PB_User_Base]