使用外连接
select t1.RQ,t1.ZYDXBSM,t1.zymc,sum(t1.jbrksl),,nvl(sum(t4.a),0),nvl(sum(t4.f),0)
from xsuser.ckkcglmxz t1,
( select t3.jbxcsl a,t3.rq b ,t3.zydxbsm c,t3.zymc d,t3.jldw e,t3.jbxcsl*t3.jbcbdj f
from xsuser.ckkcglmxz t3 )t4
where t1.rq-1(+)=t4.b and trim(t1.zydxbsm(+))=trim(t4.c)
and trim(t1.zymc(+))=trim(t4.d) and trim(t1.jldw(+))=trim(t4.e)
group by t1.rq,t1.ZYDXBSM,t1.zymc
select t1.RQ,t1.ZYDXBSM,t1.zymc,sum(t1.jbrksl),,nvl(sum(t4.a),0),nvl(sum(t4.f),0)
from xsuser.ckkcglmxz t1,
( select t3.jbxcsl a,t3.rq b ,t3.zydxbsm c,t3.zymc d,t3.jldw e,t3.jbxcsl*t3.jbcbdj f
from xsuser.ckkcglmxz t3 )t4
where t1.rq-1(+)=t4.b and trim(t1.zydxbsm(+))=trim(t4.c)
and trim(t1.zymc(+))=trim(t4.d) and trim(t1.jldw(+))=trim(t4.e)
group by t1.rq,t1.ZYDXBSM,t1.zymc
解决方案 »
- 如何用sql调用存储过程包里面的函数?
- pl/sqldeveloper数据导出excel表问题.在线等,急!!!!!
- 触发器的问题
- 求高手看看,这个存储过程,为什么单步执行没问题,但是运行的时候数据库就死掉了!同事说可能是死循环,但是单步执行没问题啊!
- 求SQL语句,备份、还原ORACLE数据库,最好在数据库处于打开状态下也能做。
- 我这句ORACLE SQL语句错在哪?
- 这条语句怎么写?
- 所有连接库的操作,提示没有监听器,怎么回事??
- oracle 01033错误
- 对表中数据进行合并成一条数据
- 请问我在OEM中的CONSOLE中怎么只看到有节点,没有数据库呢?怎么把数据库添加进去呢?因为我要针对一个数据库做作业。
- Oracle查询分析器2000 V1.1
select t1.RQ,t1.ZYDXBSM,t1.zymc,sum(t1.jbrksl),nvl(sum(t4.a),0),nvl(sum(t4.f),0)
from xsuser.ckkcglmxz t1,
( select t3.jbxcsl a,t3.rq b ,t3.zydxbsm c,t3.zymc d,t3.jldw e,t3.jbxcsl*t3.jbcbdj f
from xsuser.ckkcglmxz t3 )t4
where t1.rq(+)=t4.b+1 and trim(t1.zydxbsm(+))=trim(t4.c)
and trim(t1.zymc(+))=trim(t4.d) and trim(t1.jldw(+))=trim(t4.e)
group by t1.rq,t1.ZYDXBSM,t1.zymc 还是查不出结果。
select t1.RQ,t1.ZYDXBSM,t1.zymc,sum(t1.jbrksl),sum(t4.a),sum(t4.f)
from (select t.rq ,trim(t.zydxbsm) zydxbsm,trim(t.zymc) zymc,t.jbrksl,trim(t.jldw) jldw from xsuser.ckkcglmxz t) t1,
( select t3.jbxcsl a,t3.rq b ,trim(t3.zydxbsm) c,trim(t3.zymc) d,trim(t3.jldw) e,t3.jbxcsl*t3.jbcbdj f
from xsuser.ckkcglmxz t3 )t4
where t1.rq(+)=t4.b+1 and t1.zydxbsm(+)=t4.c
and t1.zymc(+)=t4.d and t1.jldw(+)=t4.e
group by t1.rq,t1.ZYDXBSM,t1.zymc
and t1.zymc(+)=t4.d and t1.jldw(+)=t4.e 写成t4.b(+)=t1.rq-1 and t4.c(+)=t1.zydxbsm and t4.d(+)=t1.zymc and t4.e(+)=t1.jldw
多谢了!