原本的sql语句如下:
SELECT
distinct
SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
,(SR2STRK+SR2STRK2+SR2TAX) as SR2_KINGAKU,
(SR1STRK+SR1STRK2+SR1TAX) as SR1_KINGAKU
FROM SASR_TT_SR1,SASR_TT_SR2,SAZI_TM_PRI ,SAMT_TM_TRI
WHERE SR1DPNO = SR2DPNO
AND (SR2PRCD = PRIPRCD AND SR2MJCD = PRIMJCD )
AND (SR1SRCD = TRITRCD AND SR1MJCD =TRIMJCD)
AND SR1MJCD = '2779999999'
AND SR1TRDT >='2008/09/01'
AND SR1TRDT <='2008/09/30'AND (SR1UPK7='0' or SR1UPK7= '')
order by SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
查询出来的结果如图显示:
sr1dpno sr2dgno sr2_kingaku sr1_kingaku
00006 1 26250 26250
00043 1 1000 152250
00043 2 102900 152250我现在要求SR1_KINGAKU的和
应该怎么样写才能在求和的时候不会把重复的SR1DPNO的SR1_KINGAKU的値重复相加多次
SELECT
distinct
SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
,(SR2STRK+SR2STRK2+SR2TAX) as SR2_KINGAKU,
(SR1STRK+SR1STRK2+SR1TAX) as SR1_KINGAKU
FROM SASR_TT_SR1,SASR_TT_SR2,SAZI_TM_PRI ,SAMT_TM_TRI
WHERE SR1DPNO = SR2DPNO
AND (SR2PRCD = PRIPRCD AND SR2MJCD = PRIMJCD )
AND (SR1SRCD = TRITRCD AND SR1MJCD =TRIMJCD)
AND SR1MJCD = '2779999999'
AND SR1TRDT >='2008/09/01'
AND SR1TRDT <='2008/09/30'AND (SR1UPK7='0' or SR1UPK7= '')
order by SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
查询出来的结果如图显示:
sr1dpno sr2dgno sr2_kingaku sr1_kingaku
00006 1 26250 26250
00043 1 1000 152250
00043 2 102900 152250我现在要求SR1_KINGAKU的和
应该怎么样写才能在求和的时候不会把重复的SR1DPNO的SR1_KINGAKU的値重复相加多次
解决方案 »
- java基础问题
- 一个hibernate的问题,请大侠们帮忙
- oracle存储过程中如果返回游标类型(REF CURSOR)用C++或者Qt的什么变量获得?
- 装ORACLE时把字符集设置成了UTF8,这样好不好,是不是占用空间大,和GBK有什么区别,我用的ORACLE10
- 关于数据库初始化参数问题,高分求助!
- 求救~!高手请进
- Oracle是否支持级联更新?怎么实现?
- 菜鸟真诚寻求请教。100分都是你的
- 如何获取Oracle中表、存储过程、视图的创建、修改时间?
- 急,在ORACLE8i里面用什么SQL语句查数据库里面有哪些表呢?
- 请大家推荐ORACLE好书
- undo_management是“AUTO”。为什么OEM中的 “段管理”是MANUAL?
请哪位了解或许知道是告诉我一下吧