declare @re varchar(8000) set @re='' select @re=@re+','+cast(c as varchar) from tb where a=@a and b=@b
SELECT A,B FROM tb_name GROUP BY A,B HAVING COUNT(*)>1
select a,b from t group a,b having count(*)>1
--合并函数 create function fs(@A varchar(10),@B varchar(10)) returns varchar(100) as begin declare @sql varchar(100) select @sql=isnull(@sql+',','')+ltrim(C) from 表名 where A=@A and B=@B return @sql end go--调用 select distinct A,B,dbo.fs(A,B) from 表名
SELECT A,B FROM tb_name GROUP BY A,B HAVING COUNT(*)>1这个很好,很经典!
--定义函数 CREATE function dbo.f_hb(@a varchar(15),@b nvarchar(100) returns varchar(8000) as begin declare @re varchar(8000) set @re='' select @re=@re+','+cast(c as varchar) from tb where a=@a and b=@b return(stuff(@re,1,1,'')) end --调用 select a,b,c=dbo.f_hb(a,b) from tb
SELECT A,B FROM tbl GROUP BY A,B HAVING COUNT(*)>1
SELECT A,B,sum(c) as c FROM tb_name GROUP BY A,B HAVING COUNT(*)>1 这个很好,很经典!
select A,B from tablename group by A,B having count(*)>1
set @re=''
select @re=@re+','+cast(c as varchar)
from tb
where a=@a and b=@b
FROM tb_name
GROUP BY A,B
HAVING COUNT(*)>1
--合并函数
create function fs(@A varchar(10),@B varchar(10))
returns varchar(100)
as
begin
declare @sql varchar(100)
select @sql=isnull(@sql+',','')+ltrim(C) from 表名 where A=@A and B=@B
return @sql
end
go--调用
select distinct A,B,dbo.fs(A,B) from 表名
FROM tb_name
GROUP BY A,B
HAVING COUNT(*)>1这个很好,很经典!
CREATE function dbo.f_hb(@a varchar(15),@b nvarchar(100)
returns varchar(8000)
as
begin
declare @re varchar(8000)
set @re=''
select @re=@re+','+cast(c as varchar)
from tb
where a=@a and b=@b
return(stuff(@re,1,1,''))
end
--调用
select a,b,c=dbo.f_hb(a,b) from tb
GROUP BY A,B
HAVING COUNT(*)>1
FROM tb_name
GROUP BY A,B
HAVING COUNT(*)>1 这个很好,很经典!
from tablename
group by A,B
having count(*)>1