数据库字段:到期日期(dqrq),贷款金额(dkje)
统计贷款日期为正常的贷户数和贷款金额。with data.ADOQuery1 do
begin
close;
sql.Clear;
sql.Add('select * from hqdk where dqrq>'+inttostr(trunc(date)));
open;
label5.Caption:=inttostr(data.ADOQuery1.RecordCount);
要统计正常贷户的合计贷款金额如和能实现?
统计贷款日期为正常的贷户数和贷款金额。with data.ADOQuery1 do
begin
close;
sql.Clear;
sql.Add('select * from hqdk where dqrq>'+inttostr(trunc(date)));
open;
label5.Caption:=inttostr(data.ADOQuery1.RecordCount);
要统计正常贷户的合计贷款金额如和能实现?
select sum(dkje) from ...
group by ...