【SQL 技巧】营销数据如何用 DataEase 做累计数据查看

select

month '月份',

sales '销售额',

(

select

sum(sales)

from

monthlysales ms

where

ms.month <= m.month) '月累计销售额',

cost '成本',

(

select

sum(cost)

from

monthlysales ms

where

ms.month <= m.month) '月累计成本',

profit '利润',

(

select

sum(profit)

from

monthlysales ms

where

ms.month <= m.month) '月累计利润',

order_num '订单数',

(

select

sum(order_num)

from

monthlysales ms

where

ms.month <= m.month) '月累计订单数',

quantity '产品数',

(

select

sum(quantity)

from

monthlysales ms

where

ms.month <= m.month) '月累计产品数'

from

monthlysales m

order by

m.month;