Ò»Ìõ¡¡¼òµ¥ SqlÓï¾äÎÊÌâ(SqlServer»·¾³)

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;