[MSSQL] STRING_AGG (GROUP_CONCAT)

STRING_AGG 

• 여러 row 값을 선언된 구분자를 통해 (Ex , - : ) 하나의 문자열을 나타낸다.

예시

OrderID	ProductName
1	Laptop
1	Mouse
2	Smartphone
2	Headphones
3	Tablet

SELECT OrderID, STRING_AGG(ProductName, ', ') AS ConcatenatedProducts
FROM Orders
GROUP BY OrderID;

결과 값

OrderID	ConcatenatedProducts
1	Laptop, Mouse
2	Smartphone, Headphones
3	Tablet

Reference

MYSQL GROUP_CONCAT (세로컬럼 가로로 합치기 )

---

There might be incorrect information or outdated content.