select dm,bm,sum(a1) from czbtem group by bm
//or
select sum(a1) from czbtem group by bm
//or
select sum(a1) from czbtem group by bm
解决方案 »
- delphi 做手机 要哪些 插件
- 深受黑公司其害,大家报一下给黑过的公司,让大伙注意!
- 能否用程序为WINDOWS打印机添加自定义纸张?
- indy9如何确定邮件是否已经成功发送
- 想问高手如何用vfp调用DELPHI编写的DLL?
- 一个关于PSmallint的问题
- *********************火急求救*********************
- 怎么老说我的存储过程的参数找不到???
- 用Query对数据库进行Update操作,麻烦帮忙看看,错在哪里?
- 声明共享内存的tsharemem结构时,^这个符号是什么意思的?
- 在win98下学习Delphi需要安装哪些软件,网上有没有免费下载?另外,有什么好的学习用书?谢谢!
- 还是MIDAS的分发调试问题!请一定进来看看!!!非常感谢!
// ~~~~~
//or
select sum(a1) from czbtem group by bm
select <显示字段>,sum() as <计算字段>
from
group by <分组字段>
SELECT SUM(a1) from czbtem GROUP BY bm
再请看看,多谢了!
query1.sql.add('selectsum(a1),sum(a2),sum(a3),sum(a4),sum(a5),sum(a6),sum(a7),sum(a8),sum(a9),sum(a10),sum(a11),sum(a12),sum(a13) from czbtem group by bm');按下面写法出错是:When GROUP BY exists,every simple field in projectors must be in GROUP BY...
query1.sql.add('select dm,dw,dm,sum(a1),sum(a2),sum(a3),sum(a4),sum(a5),sum(a6),sum(a7),sum(a8),sum(a9),sum(a10),sum(a11),sum(a12),sum(a13) from czbtem group by bm');
from Czbtem A,
(select Bm,sum(a1) from czbtem group by bm) B
where A.Bm = B.Bm
Invalid use of keyword
Token:select
Line Number:1
请问我应该怎么改,谢谢了!
procedure TForm1.Button41Click(Sender: TObject);
begin
with query1 do begin
close;
sql.clear;
sql.add('select A.dm,B.SumValue from Czbtem A,(select Bm,sum(a1) from czbtem group by bm) B where A.Bm = B.Bm');
open;
end;
end;