컬럼 묶어서 보여줄 때

with tab1 as (

select 'AAA' CODE,'홍기동'NAME union all
select 'AAA' CODE,'양수동'NAME union all
select 'AAA' CODE,'동동동'NAME union all

select 'BBB' CODE,'월미도'NAME union all
select 'BBB' CODE,'강원도'NAME union all
select 'BBB' CODE,'삽교천'NAME union all
select 'BBB' CODE,'천박해'NAME union all

select 'CCC' CODE,'우주로'NAME

)

 

 

select
replace(
replace(
(
SELECT  STUFF((
    SELECT N',' + name
    FROM tab1
    WHERE code = st1.code
    FOR XML PATH('')
  ), 1, 1, N'') AS name
FROM tab1 st1
GROUP BY code  for xml path('')

)
,'</name>',''',')
,'<name>','''') +''''''
 as names