select source_id,deposit_comp,comp_phone,comp_addr,deposit_client,client_phone,sum(total_amt)
from sale_card_request
group by source_id,deposit_comp,comp_phone,comp_addr,deposit_client,client_phone
sale_card_request 有个 req_date 的字段，比如我想查 req_date between '2000-1-1' and '2010-1-1' 这间的数据并且使用上面的分组怎么实现？
delphi
Delphi(Pascal) code:
with ADOQuery do
begin
close;
sql.add('select source_id,deposit_comp,comp_phone,comp_addr,deposit_client,client_phone,sum(total_amt)');
sql.add('from sale_card_request');
sql.add('where req_date>='+QuotedStr('2000-1-1')+' and req_date<='+QuotedStr('2000-1-1'));//QuotedStr中可以替换成变量,字符型
sql.add('group by source_id,deposit_comp,comp_phone,comp_addr,deposit_client,client_phone');
open
end;
