select a.v1-b.v1
from (select id,v1 from t2 where id>1) a,
(select id,v1 from t2 where id<>(select max(id) from t2)) b
where a.id=b.id+1
sql 实现相邻两条数据之差
最新推荐文章于 2023-11-12 21:08:38 发布
select a.v1-b.v1
from (select id,v1 from t2 where id>1) a,
(select id,v1 from t2 where id<>(select max(id) from t2)) b
where a.id=b.id+1