select
sdate,lag(结存,1,0)over(order by sdate)as 期初,
warehouse,ex_warehouse,结存
from(
select s.*,sum(s.warehouse-s.ex_warehouse)over(order by sdate) as 结存 from stock s
);
查询每天的期初数,入库,出库,结存数。
select
sdate,lag(结存,1,0)over(order by sdate)as 期初,
warehouse,ex_warehouse,结存
from(
select s.*,sum(s.warehouse-s.ex_warehouse)over(order by sdate) as 结存 from stock s
);
查询每天的期初数,入库,出库,结存数。