weixin_42767581的博客

业务场景：计算sales/count/sku的值、同比、环比用开窗函数neighbor计算yoy同比和chain环比//原本计算同比和环比需要使用三条sql聚合后相除SELECT toStartOfYear(toDate('2020-05-01')) AS date, ROUND(SUM(sales), 2) AS sales, SUM(count) AS count, COUNT(DISTINCT product_id) AS skuFROM mars_rc_roma_wide.