mysql 实现相邻两条数据相减
mysql 实现相邻两条数据相减要计算mysql同列当中,当前数据前去上一个数据的差查询数据SELECT a.`STORE_ID` AS id,a.`STORE_NAME` AS NAME,a.`DEPOSIT` AS curr,@a.DEPOSIT AS pre, //上一条记录的deposit值@a.DEPOSIT:= a.DEPOSIT AS tmpFROM stock_store_addinfo a,(SELECT @a.DEPOSIT:=0)s@a.DEPOS
转载
2021-09-30 11:37:00 ·
1612 阅读 ·
0 评论