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

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

 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  

ORACLE数据库写法SELECT BQMC || '|' || replace(WMSYS.WM_CONCAT(NR),',',';' ) AS AA FROM TABLE_t1 GROUP BY BQMC