var str_sql:string;str_sql:='select xm,sumsl=sum(sl) from xs group by xm order by xm compute sum(sl)'; query1.close; query1.sql.clear; query1.sql.add(str_sql); query1.open; query1.locate( .....) result:=query1.fieldbyname('sumsl').asfloat;
group by 与 compute 能同时用吗? --------------------------------- select xm,aa=sum(sl) from xs //有的数据库不支持,可用sum(sl) as aa group by xm order by xm --------------------------------- 问题很简单,试一试吧
var str_sql:string;str_sql:='select xm,sumsl=sum(sl) from xs group by xm order by xm compute sum(sl)';
query1.close;
query1.sql.clear;
query1.sql.add(str_sql);
query1.open;
query1.locate( .....)
result:=query1.fieldbyname('sumsl').asfloat;
---------------------------------
select xm,aa=sum(sl) from xs //有的数据库不支持,可用sum(sl) as aa
group by xm
order by xm
---------------------------------
问题很简单,试一试吧