规则是:取那些Column非0的记录的最大值为起始值.?
Column??(A OR B OR C)没看明白
Column??(A OR B OR C)没看明白
解决方案 »
- 请高手帮我分析下下面两个SQL语句为什么执行效率有差异??
- oracle基础问题
- 超级 sql语句难题。解决不了,老板要开除我。没有饭吃啊
- 是否有专用工具,可将sqlserver的数据实时更新到oracle的表中??
- 急!!oracle 9i安装问题!!!
- 帮忙解释over的用法
- 实现如此功能的sql怎么写,请高手不吝赐教
- 存储过程的问题
- 大家经常提到的关于update问题(exists(select 1 from temp_xdata b where b.userid = 1 and b.colname = 'mcxh' and a.mcnbxh = b.olddat
- 简单问题请教?
- 如果查找表所属的表空间
- oracle 10g安装时,无法确定主机ip地址?
from
tt1,
(
select id,ca,cb,cc,row_number() OVER (PARTITION BY ca,cb ORDER BY id) rm,(select max(t.cc) from tt1 t where t.ca = tt1.ca and t.cb = tt1.cb) mc from tt1
where cc= 0
) t1
where tt1.id = t1.id(+)
select t.id,t.aa,t.bb,decode(t.cc,0,tt.cc+t.dd,t.cc)
from (select id,aa,bb,cc,(row_number() over(partition by aa,bb order by cc,id)) dd from qwe) t,
(select aa,bb,max(cc) cc from qwe group by aa,bb) tt
where t.aa=tt.aa and
t.bb=tt.bb
order by id
-----------------------------------这个也可以
t.id,t.aa,t.bb,decode(t.cc,0,tt.ee+tt.dd,t.cc)
from qwe t,
(select id,aa,bb,(row_number() over(partition by aa,bb order by cc,id)) dd ,
(select max(m.cc) from qwe m where m.aa=n.aa and m.bb=n.bb group by m.aa,m.bb) ee from qwe n) tt
where t.aa=tt.aa and
t.bb=tt.bb and
t.id=tt.id
order by id
from qwe t,
(select id,aa,bb,(row_number() over(partition by aa,bb order by cc,id)) dd ,
(select max(m.cc) from qwe m where m.aa=n.aa and m.bb=n.bb group by m.aa,m.bb) ee from qwe n) tt
where t.aa=tt.aa and
t.bb=tt.bb and
t.id=tt.id
order by id