数据库查询问题，求大神帮忙解决

Question

Answer 1

declare @tb table
(
BQMC varchar(50),
NR varchar(10)
)

insert into @tb values('cpts', 'lalala')
insert into @tb values('cpts', 'huahuahua')
insert into @tb values('fwnr', '123456')
insert into @tb values('fwnr', '789')

select BQMC, ep_name = (stuff((select ',' + NR from @tb where BQMC =

a.BQMC for xml path('')),1,1,'')) from @tb a group by BQMC