SQL下一行减去上一行的值插入另一表

SQL下一行减去上一行的值插入另一表
测试数据.
CREATE TABLE temp (
year INT,
salary INT
);

INSERT INTO temp VALUES(2000, 1000);
INSERT INTO temp VALUES(2001, 2000);
INSERT INTO temp VALUES(2002, 3000);
INSERT INTO temp VALUES(2003, 4000);

大概sql语句就这样了。没有执行，也不知道是不是你想要的。
SELECT 收入1-收入 AS 收入差
FROM
(
SELECT * FROM (SELECT * FROM (select Row_Number() over ( order by 时间 ) as rn1 , 收入 AS 收入1 from rn_ext_vir_instance_charge_history) AA) BB
INNER JOIN
(SELECT * FROM (SELECT * FROM (select Row_Number() over ( order by 时间 ) as rn , 收入 from rn_ext_vir_instance_charge_history) CC) DD) EE
ON BB.rn1=EE.rn+1
)FF

悬赏太少，写出来后，注释你未必能明白。
告诉你思路吧，其实使用中间变量就可以做到的