有一张表, 数据如下
ID | NAME | PRICE | time
1 name1 100 2012/01/01
2 name2 200 2012/01/02
3 name3 800 2012/01/03
查询理想结果
ID | NAME | PRICE | time | chajia
1 name1 100 2012/01/01 0
2 name2 200 2012/01/02 100
3 name3 800 2012/01/03 600
ID | NAME | PRICE | time
1 name1 100 2012/01/01
2 name2 200 2012/01/02
3 name3 800 2012/01/03
查询理想结果
ID | NAME | PRICE | time | chajia
1 name1 100 2012/01/01 0
2 name2 200 2012/01/02 100
3 name3 800 2012/01/03 600
select tb.*,nvl(PRICE-prior PRICE,0) from tb start with id=1 connect by id = prior id+1
select id,name,price,time,lag(h.price)over(order by h.id) as lastval
from tableName h;