<p>출처1 :&nbsp;<a href="http://blog.daum.net/devgroup/31" target="_blank" title="[http://blog.daum.net/devgroup/31]로 이동합니다.">http://blog.daum.net/devgroup/31</a><br>출처2 :&nbsp;<a href="https://stackoverflow.com/questions/1817985/how-do-i-create-a-comma-separated-list-using-a-sql-query">https://stackoverflow.com/questions/1817985/how-do-i-create-a-comma-separated-list-using-a-sql-query</a><br>출처3 :&nbsp;<a href="https://oracle-base.com/articles/misc/string-aggregation-techniques">https://oracle-base.com/articles/misc/string-aggregation-techniques</a><br>
<br><br><br><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">--&nbsp;MySQL</span></div><div>&nbsp;&nbsp;<span style="color: #569cd6;">SELECT</span>&nbsp;r.name,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GROUP_CONCAT(a.name&nbsp;SEPARATOR&nbsp;<span style="color: #ce9178;">','</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;RESOURCES&nbsp;r</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;APPLICATIONSRESOURCES&nbsp;ar&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;ar.resource_id&nbsp;=&nbsp;r.id</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;APPLICATIONS&nbsp;a&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;a.id&nbsp;=&nbsp;ar.app_id</div><div><span style="color: #569cd6;">GROUP&nbsp;BY</span>&nbsp;r.name</div><br><div><span style="color: #6a9955;">--SQL&nbsp;Server&nbsp;(2005+)</span></div><div><span style="color: #569cd6;">SELECT</span>&nbsp;r.name,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #dcdcaa;">STUFF</span>((<span style="color: #569cd6;">SELECT</span>&nbsp;<span style="color: #ce9178;">','</span>+&nbsp;a.name</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;APPLICATIONS&nbsp;a</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;APPLICATIONRESOURCES&nbsp;ar&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;ar.app_id&nbsp;=&nbsp;a.id</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">WHERE</span>&nbsp;ar.resource_id&nbsp;=&nbsp;r.id</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">GROUP&nbsp;BY</span>&nbsp;a.name</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FOR&nbsp;<span style="color: #569cd6;">XML</span>&nbsp;<span style="color: #569cd6;">PATH</span>(<span style="color: #ce9178;">''</span>),&nbsp;<span style="color: #569cd6;">TYPE</span>).<span style="color: #569cd6;">value</span>(<span style="color: #ce9178;">'.'</span>,<span style="color: #ce9178;">'VARCHAR(max)'</span>),&nbsp;<span style="color: #b5cea8;">1</span>,&nbsp;<span style="color: #b5cea8;">1</span>,&nbsp;<span style="color: #ce9178;">''</span>)</div><div>&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;RESOURCES&nbsp;r</div><br><div><span style="color: #6a9955;">--SQL&nbsp;Server&nbsp;(2017+)</span></div><div>&nbsp;&nbsp;<span style="color: #569cd6;">SELECT</span>&nbsp;r.name,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #dcdcaa;">STRING_AGG</span>(a.name,&nbsp;<span style="color: #ce9178;">','</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;RESOURCES&nbsp;r</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;APPLICATIONSRESOURCES&nbsp;ar&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;ar.resource_id&nbsp;=&nbsp;r.id</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;APPLICATIONS&nbsp;a&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;a.id&nbsp;=&nbsp;ar.app_id</div><div><span style="color: #569cd6;">GROUP&nbsp;BY</span>&nbsp;r.name</div><br><div><span style="color: #6a9955;">--Oracle</span></div><div>I&nbsp;recommend&nbsp;reading&nbsp;about&nbsp;string&nbsp;aggregation/concatentation&nbsp;<span style="color: #569cd6;">in</span>&nbsp;Oracle.</div><div><span style="color: #569cd6;"><a href="http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php" target="_blank" class="tx-link">http</a></span><a href="http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php" target="_blank" class="tx-link">://www.oracle-base.com/articles/10g/StringAggregationTechniques.php</a></div><div><br></div></div><br><br><br><br><br><br>
<br>
<b>[로우 데이터]</b><table style="WIDTH: 174px; BORDER-COLLAPSE: collapse; HEIGHT: 163px" cellspacing="1" cellpadding="1" width="174" bgcolor="#ffffff">
<tbody>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;ID</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">Title&nbsp;</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;1</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;가</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;1</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;나</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;1</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;다</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;2</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;라</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;2</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;마</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;2</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;바</td>
</tr>
</tbody></table>
<br>
<br>
<br>
<br>
<br>
<b>[결과]</b><table style="WIDTH: 174px; BORDER-COLLAPSE: collapse; HEIGHT: 46px" cellspacing="1" cellpadding="1" width="174" bgcolor="#ffffff">
<tbody>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;ID</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">Title&nbsp;</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;1</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;가, 나, 다</td>
</tr>
<tr>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;2</td>
<td style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="50%">&nbsp;라, 마, 바</td>
</tr>
</tbody></table>
<br>
<br>
<br>
<br><b>[쿼리]</b><br>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;color:blue;
mso-font-kerning:0pt;mso-no-proof:yes">SELECT</span><span style=";font-family:Consolas;mso-font-kerning:0pt;
mso-no-proof:yes"> <span style="color:blue">DISTINCT</span></span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:teal">ID</span><span style="color:gray">,</span> </span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:fuchsia">STUFF</span><span style="color:gray">((</span></span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:blue">SELECT</span> <span style="color:red">', '</span> <span style="color:gray">+</span> <span style="color:teal">Title</span></span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:blue">FROM</span>&nbsp;&nbsp;&nbsp; <span style="color:teal">TB_Data</span> <span style="color:teal">b</span> </span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:blue">WHERE</span>&nbsp;&nbsp; <span style="color:teal">b</span><span style="color:gray">.</span><span style="color:teal">ID</span> <span style="color:gray">=</span> <span style="color:teal">a</span><span style="color:gray">.</span><span style="color:teal">ID</span></span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:blue">FOR</span> <span style="color:blue">XML</span> <span style="color:blue">PATH</span><span style="color:gray">(</span><span style="color:red">''</span><span style="color:gray">)</span></span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color:gray">),</span>1<span style="color:gray">,</span>2<span style="color:gray">,</span><span style="color:red">''</span><span style="color:gray">)</span> <span style="color:blue">AS</span> <span style="color:teal">NAME</span> </span></p>
<p align="left" style="margin-bottom: 0.0001pt; line-height: normal;"><span style=";font-family:Consolas;mso-font-kerning:
0pt;mso-no-proof:yes">&nbsp;<span style="color:blue">FROM</span> <span style="color:teal">TB_Data</span> <span style="color:teal">a</span></span></p>
<p style="margin: 0px; padding: 0px; line-height: 1.6; font-family: 돋움, dotum, verdana, sans-serif;">

















</p>
<p><span>&nbsp;</span></p>
<br>
<br>
<br>
<p><br></p>


[MS-SQL] 여러 Row를 하나의 Row로 합치기 세로를 가로로 배치 콤마 구분