WITH t AS ( SELECT 1 no, '안녕하세요' nm, 'A' cd UNION ALL SELECT 2, '반가워요', 'B' UNION ALL SELECT 3, '즐거워요', 'C' ) SELECT STRING_AGG(no, CONCAT(CHAR(13), CHAR(10))) WITHIN GROUP(ORDER BY no) no , STRING_AGG(nm, CONCAT(CHAR(13), CHAR(10))) WITHIN GROUP(ORDER BY no) nm , STRING_AGG(cd, CONCAT(CHAR(13), CHAR(10))) WITHIN GROUP(ORDER BY no) cd FROM t ; http://gurubee.net/article/55512