[求助]一道有点难度的sql
有一张表为a 1
b 2
b 3
c 4
c 5
c 6
请用ＳＱＬ变为
a 1
b 23
c 456
请问怎么实现？
create table t(n varchar(10),i int)
insert t select 'a',1
union select 'b',2
union select 'b',3
union select 'c',4
union select 'c',5
union select 'c',6
select * from t
create function m(@i varchar(10))
returns varchar(200)
as
begin
declare @n varchar(2000)
set @n=''
select @n=@n+''+cast(i as varchar) from t where n=@i
return @n
end
select distinct n,dbo.m(n) as s from t
楼上的真的很热心，不过这样的问题基本没什么价值！
