SQL进销存明细计算

linmeici

这种类似于三栏明细账的SQL计算代码,好难找,把他简化后赶紧备份一个在这里.

linmeici

SELECT a.ID, a.品名, a.入库, a.出库, (select sum(入库-出库) as 库存 from 表1 b where b.品名=a.品名 and b.id<=a.id) AS 库存
FROM 表1 AS a
WHERE ID>3
GROUP BY a.ID, a.品名, a.入库, a.出库
ORDER BY 品名;