oracle数据库求差值的sql语句.
表A中有shuzhi和riqi两个字段，分别是数字类型和字符串类型。数据如下：
shuzhi riqi
2 20140101
5 20140201
9 20140301
我想要的是，下面一条的shuzhi减去上一条得到一个值：
shuzhi riqi
2 20140101
3 20140201
4 20140301
第1个回答 推荐于2017-09-24
with t1 as (
select shuzi,riqi,rownum as rn
from (select shuzi,riqi
from A
order by 2) t
)
select p.shuzi-nvl(m.shuzi,0) as new_shuzi,p.riqi
from t1 p
left join t1 m on p.rn-1=m.rn
;
你看下这个结果本回答被提问者和网友采纳
select shuzi,riqi,rownum as rn
from (select shuzi,riqi
from A
order by 2) t
)
select p.shuzi-nvl(m.shuzi,0) as new_shuzi,p.riqi
from t1 p
left join t1 m on p.rn-1=m.rn
;
你看下这个结果本回答被提问者和网友采纳
相似回答
