select field1,field2,MySum(Field3) As MyField from table Group By Field1,Field2这里的MySum是自定义函数
解决方案 »
- 复合索引疑问
- 查询空的怎么查
- 用log explorer 恢复删除的数据表,提示 getrow() NUll
- 内连续上班等于或大于4天的员工
- 应该简单,触发器的问题。 (我想知道数据修改前和修改后的内容)
- 安装SQL Server2000时出现下面的提示:Microsoft SQL Server 2000 Enterprise Edition服务器组件在此操作系统上不受支持,只有客户端组件
- 怎么设置远程数据库?
- 简单 SQL????????????????????????/
- 如何进行按时间段过滤数据
- sql 关于like查询的问题
- 肯请赐教:job里面的这个SQL语句怎么实现?
- 難題一道,難難難難難難........高手請進,接招吧.
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+rtrim(field3)
from table
where field1=@field1 and field2=@field2
set @str=right(@str,len(@str)-1)
return @str
end
go
你试试
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+cast(field3 as varchar(10)) from table1 where field1=@content and field2=@a
set @str=right(@str,len(@str)-1)
return @str
end
go--调用:
select field1,field2,dbo.getstr(field1,c) from table1 group by field1,field2
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+rtrim(field3)
from table
where field1=@field1 and field2=@field2
set @str=right(@str,len(@str)-1)
return @str
end
go
select field1,field2 getstr(field1,field2) field3 from table group by field1,field2
drop function Your
from table1
group by field1,field2CREATE FUNCTION f(@v varchar(20))
RETURNS varchar(200) AS
DECLARE @str varchar(200)
SELECT @str=@str+filed3 FROM WHERE field1 = @v
RETURN @str