要求：根据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 @
2008-01-21 11:33 CoderDream 阅读(202) |
评论 (0) |
编辑 收藏