sql 多行某字段内容合并

sql server:

实例1:

CREATE TABLE test(NAME VARCHAR(10),CONTENT VARCHAR(50));

INSERT INTO dbo.test
( NAME, CONTENT )
SELECT '张三','张三1'
UNION ALL 
SELECT '李四','李四1'
UNION ALL 
SELECT '张三','张三2'
UNION ALL 
SELECT '张三','张三3'
UNION ALL 
SELECT '李四','李四2'; 

SELECT * FROM test;

select name,
CONTENT=stuff((select ','+rtrim( CONTENT) from test where t.name=name order by CONTENT for xml path('')),1,1,'')
from dbo.test t 
group by name
ORDER BY name desc

------------------------

张三  张三1,张三2,张三3

李四  李四1,李四2

实例2:

select
revCusEntry.FHeadID FHeadID,
FFdcCustomerID=stuff((select ';'+rtrim(fdcCus.FName_l2) from T_BDC_RevFDCCustomerEntry recCusEntry1 left join T_SHE_FDCCustomer fdcCus on recCusEntry1.FFdcCustomerID=fdcCus.FID where revCusEntry.FHeadID=recCusEntry1.FHeadID order by recCusEntry1.FFdcCustomerID for xml path('')),1,1,'')
from T_BDC_RevFDCCustomerEntry revCusEntry
group by revCusEntry.FHeadID

 

 oracle :函数：wm_concat

select WMSYS.WM_CONCAT(fassignid) from t_wfr_assigndetail where fprocinstid='02103630-6a3d-4904-9185-b445f17c3700WFPCINST'

mysql :函数：group_concat