查询问题？

Question

table a(a1,a2,a3,a4,a5)
sql:
select a1,a2,sum(a3) 
from a 
where XXXXXXXXX 
group by a1,a2,a3

Answer 1

adoquery1.sql.add('select sum(a),b,c....from ..where..');

Answer 2

var
i:integer;
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from talbename where ....)
adoquery1.parambyname(..)=value;
.
.
adoquery1.first;
for i:=1 to i=adoquery1.recordcount do
begin
result=0;
j=adoquery1.fieldbyname[..].value;
result;=result+j;
adoquery1.next;
end;

Answer 3

With AdoQuery1 do
begin
   Sql.clear;
   Sql.Add('Select A,B,Sum(C) from Table Where 条件 Group by A,B');
   Prepared;
   Open;
end;
不妨试一下