首頁猿問 MySQL-從上一行中減去值，按組

MySQL-從上一行中減去值，按組

MySQL

拉風(fēng)的咖菲貓 2019-10-18 10:23:10

我需要根據(jù)SN號在前一個基礎(chǔ)上獲得消費價值。這是我的數(shù)據(jù)：表EnergyLogSN Date Value2380 2012-10-30 00:15:51 21.012380 2012-10-31 00:31:03 22.042380 2012-11-01 00:16:02 22.652380 2012-11-02 00:15:32 23.1120100 2012-10-30 00:15:38 35.2120100 2012-10-31 00:15:48 37.0720100 2012-11-01 00:15:49 38.1720100 2012-11-02 00:15:19 38.9720103 2012-10-30 10:27:34 57.9820103 2012-10-31 12:24:42 60.83這是我需要的結(jié)果：SN Date Value consumption2380 2012-10-30 00:15:51 21.01 02380 2012-10-31 00:31:03 22.04 1.032380 2012-11-01 00:16:02 22.65 0.612380 2012-11-02 00:15:32 23.11 0.4620100 2012-10-30 00:15:38 35.21 020100 2012-10-31 00:15:48 37.07 1.8620100 2012-11-01 00:15:49 38.17 1.120100 2012-11-02 00:15:19 38.97 0.820103 2012-10-30 10:27:34 57.98 020103 2012-10-31 12:24:42 60.83 2.85

查看完整描述