先申明一个变量 var SumA6:Integer;然后写SQL语句如下 with Query1 do begin Close; DatabaseName:=DatabaseName; SQL.Clear; SQL.Add('Select Sum(A6) as SumA6 From Table '); Open; end;Open之后,写SumA6:=Query1.FieldByName('SumA6').AsInteger; 这是SumA6变量存的就是A6字段的总和了
先申明一个变量 var SumA6:Integer;然后写SQL语句如下 with Query1 do begin Close; DatabaseName:=DatabaseName; SQL.Clear; SQL.Add('Select Sum(A6) as SumA6 From Table '); Open; end;Open之后,写SumA6:=Query1.FieldByName('SumA6').AsInteger; 这是SumA6变量存的就是A6字段的总和
declare @recca declare @tmpdeclare cur1 cursor for select a6 from dbname select @tmp=0 while @@ do begin select @recca=@recca+@tmp fetch next cur1 into @tmp end好长时间没搞MSSQL,都忘掉了.
去安装个MSDN最新版参考参考!!!!
如果是用SQl语句在编程的话:
T_sqL : declare @isum integer select @Sum = sum(A6) from yourTable PL/SQL: begin declare isum int; select isum = sum(A6) from yourTable; end; 说得不对请指教
var
SumA6:Integer;然后写SQL语句如下
with Query1 do
begin
Close;
DatabaseName:=DatabaseName;
SQL.Clear;
SQL.Add('Select Sum(A6) as SumA6 From Table ');
Open;
end;Open之后,写SumA6:=Query1.FieldByName('SumA6').AsInteger;
这是SumA6变量存的就是A6字段的总和了
var
SumA6:Integer;然后写SQL语句如下
with Query1 do
begin
Close;
DatabaseName:=DatabaseName;
SQL.Clear;
SQL.Add('Select Sum(A6) as SumA6 From Table ');
Open;
end;Open之后,写SumA6:=Query1.FieldByName('SumA6').AsInteger;
这是SumA6变量存的就是A6字段的总和
declare @tmpdeclare cur1 cursor for select a6 from dbname
select @tmp=0
while @@ do
begin
select @recca=@recca+@tmp
fetch next cur1 into @tmp
end好长时间没搞MSSQL,都忘掉了.
T_sqL :
declare
@isum integer
select @Sum = sum(A6) from yourTable PL/SQL:
begin
declare
isum int;
select isum = sum(A6) from yourTable;
end; 说得不对请指教