分组统计问题,谢谢
HY HU
1 A
2 B
1 C
3 D
需要结果:
HY HU
1 A,C
2 B
3 D
[解决办法]
create table tb(HY int,HU varchar(100))
go
insert into tb
select 1, 'A ' union all
select 2, 'B ' union all
select 1, 'C ' union all
select 3, 'D '
go
--写一个聚合函数：
create function dbo.fn_Merge(@HY int)
returns varchar(8000)
as
begin
declare @r varchar(8000)
set @r= ' '
select @r=@r+ ', '+HU from tb where HY=@HY
return stuff(@r,1,1, ' ')
end
go
-- 调用函数
select HY, dbo.fn_Merge(HY) as HU from tb group by HY
go
drop table tb
drop function fn_Merge
