第1个回答 2017-08-30
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);本回答被网友采纳
第2个回答 2018-05-08
大概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