mysql 库存表 累计 sql语句 第一方法

这是一个表，要求累计金额 。表名t ，字段lsh(流水号)，shangpinbh(商品编号)，jine(金额)。

流水号	商品编号	金额	累计金额
1	1002	5100	5100
2	1002	3500	8600
3	1002	10000	18600
4	2001	2560	2560
5	2010	4700	4700

select lsh,shangpinbh,jine,
  (select sum(jine) from t where shangpinbh=t1.shangpinbh and lsh <=t1.lsh) as 累计金额
from t as t1;

mariadb> select lsh,shangpinbh,jine,
     (select sum(jine) from t where shangpinbh=t1.shangpinbh and lsh <=t1.lsh) as 累计金额
     from t as t1;
+-----+------------+-------+----------+
| lsh | shangpinbh | jine  | 累计金额 |
+-----+------------+-------+----------+
|   0 | 1002       | 5100  | 5100     |
|   1 | 1002       | 3500  | 8600     |
|   3 | 1002       | 10000 | 18600    |
|   4 | 2001       | 2560  | 2560     |
|   5 | 2010       | 4700  | 4700     |
+-----+------------+-------+----------+
5 rows in set (0.01 sec)