怎么让SQL得出的结果下一行减去上一行

如果是Sql service 了 可以
select b.相减字段-a.相减字段 from（select * from (select Row_Number() over ( order by 排序字段 ) as RN , * from Table Name) where rn%2=0） a

inner join
（select * from (select Row_Number() over ( order by 排序字段 ) as RN , * from Table Name) where rn%2<>0） b on a.rn=b.rn-1本回答被提问者采纳