여러행 문자열 합치기

 

 

 

-- MSSQL

a. STRING_AGG(column, '구분자') WITHIN GROUP (ORDER BY column)

 

b. STUFF('대상문자열', 시작위치, 크기, '변경할 문자')

SELECT DISTINCT team_name,
		STUFF(( SELECT ','+player FROM #TEMP_TABLE FOR XML PATH('') ), 1, 1, '') as playerList 
FROM TEMP_TABLE

 

 

-- ORACLE

 

LISTAGG(column, '구분자') WITHIN GROUP (ORDER BY column)

FROM TABLE

GROUP BY column2

 

 

 

-- MYSQL

 

GROUP_CONCAT(column SEPARATOR '구분자')

 

 

 

* STUFF() / FOR XML PATH 참고 : https://vmpo.tistory.com/83