27,579
社区成员
发帖
与我相关
我的任务
分享
if OBJECT_ID('tempdb..#ta') > 0
drop table #ta
create table #ta
(zd1 int, zd2 varchar(10), zd3 varchar(10), zid4 varchar(10))
insert into #ta values
(1, 'A', 'B', 'AA'),
(1, 'A', 'B', 'BB'),
(2, 'C', 'Q', 'CC'),
(2, 'C', 'Q', null),
(2, 'C', 'Q', 'DD')
select
zd1
,zd2
,zd3
,zd4=(
select zid4 + ' ' from #ta where zd1 = a.zd1 for xml path('')
)
from
#ta a
group by zd1,zd2,zd3