Versions Compared

Old Version 28

changes.mady.by.user 管理员

Saved on

compared with

New Version 29

changes.mady.by.user 管理员

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

计算上月汇总的数量的SQL：

select 月份,sum(数量) as 数量 ,
( select sum(数量) from workbook1 t2 where
t2.月份||'-01'=date(t1.月份||'-01','-1 month')
) as 上月数量
from workbook1 t1 group by 月份