with tmp as(
select '1' id ,'aa' name ,'22' age from dual union all
select '2' id ,'bb' name ,'20' age from dual union all
select '3' id ,'CC' name ,'21' age from dual
)
select a.*,
lead(age,1) over (order by id desc) lag,
a.age - lead(age,1) over (order by id desc) lag1
from tmp a

lead函数是按id倒序排序把下一行的age记录显示在当前行的列lag,为null显示null

 

with tmp as(
select '1' id ,'aa' name ,'22' age from dual union all
select '2' id ,'bb' name ,'20' age from dual union all
select '3' id ,'CC' name ,'21' age from dual
)
select a.*,
lag(age,1) over (order by id desc) lag,
a.age - lag(age,1) over (order by id desc) lag1
from tmp a

lag函数是按id倒序排序把上一行的age记录显示在当前行的列lag,为null显示null

 

转载自:https://www.cnblogs.com/qingfengliaoren/p/5647800.html

posted on   itprobie-菜鸟程序员  阅读(374)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示