简单送５０分．求一个表中的满足条件的数据的和．(50分)

塬上独狼 · 2008-12-08

用ＡＤＯtable?或者sql?要代码．

erzhong008 · 2008-12-08

太抽象了，属于哲学问题.

lyunp · 2008-12-08

万能的主会你这个问题！

szhcracker · 2008-12-08

大致应该类似于如下的语句：
Select card_number, Sum(amount) sa From Card
Where card_number > 100
Group By card_number

塬上独狼 · 2008-12-08

不好意思,我在说明确点:求数值1的和减去数值2的和.当姓名:=张三.
姓名数值1 数值2
张三 1 0
张三 1 0
李四 0 1

power255 · 2008-12-08

select sum(数值1)-sum(数值2) from 表名 where 姓名='张三'

sunboy_del · 2008-12-08

select sum(数值1-数值2) sa from tablename where xm='张三'

塬上独狼 · 2008-12-08

procedure TForm1.Button2Click(Sender: TObject);
begin
adoquery1.sql.clear;
adoquery1.sql.add('select sum(收入-支出 )as sm from water1 where 审批人=edit3.text');
adoquery1.open;
edit2.Text:=adoquery1.fieldbyname('sm').asstring;

end;
麻烦看一下，提示：edit3.text没有初始值．

creation-zy · 2008-12-08

adoquery1.sql.add('select sum(收入-支出)as sm from water1 where 审批人=' + QuotedStr(edit3.text) ); //edit3.text应当这样拼接进SQL中

塬上独狼 · 2008-12-08

正解：where 审批人=＂＇＋edit3.text＋＇＂

简单送５０分．求一个表中的满足条件的数据的和．(50分)

塬上独狼

Unregistered / Unconfirmed

erzhong008

Unregistered / Unconfirmed

lyunp

Unregistered / Unconfirmed

szhcracker

Unregistered / Unconfirmed

塬上独狼

Unregistered / Unconfirmed

power255

Unregistered / Unconfirmed

sunboy_del

Unregistered / Unconfirmed

塬上独狼

Unregistered / Unconfirmed

creation-zy

Unregistered / Unconfirmed

塬上独狼

Unregistered / Unconfirmed

Similar threads