要求:根据Reinsurance_Level和ReCompanyCode进行汇总:
select t.reinsurance_Level,t.re_Company_Code,sum(t.ceded_Amount)
from Claimnotice_Insurance_Detail t
where 1=1
-- 此处加条件
group by t.reinsurance_Level,t.re_Company_Code;
结果:
REINSURANCE_LEVEL |
RE_COMPANY_CODE |
3 |
1 |
1 |
2621000 |
1 |
2 |
1534000 |
1 |
3 |
375000 |
Q |
2 |
302000 |
Q |
4 |
302000 |
posted on 2008-01-21 11:33
CoderDream 阅读(675)
评论(0) 编辑 收藏 所属分类:
再保系统