m0_56148755的博客

原创 同比环比 sql 帆软frdemo订单表，订单明细表

with tab1 as(select a.原年月,a.原数量,(select b.原数量 from(select substr(订购日期,0,8)原年月,sum(数量)原数量 from 订单 left join 订单明细 on 订单.订单ID=订单明细.订单ID group by substr(订购日期,0,8))bwhere b.原年月 = substr(DATE(a.订购日期,'-1 month'),0,8))上月from (select substr(订购日期,0,8)原年月,sum(.