[bigquery]累積値を算出する

2021-09-18 2022-05-09

SELECT

, date

, price

-- 累積金額の算出　id単位でdate順に並べ替えて、priceを累積していく

, SUM(price) OVER (PARTITION BY id ORDER BY sales_date ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as price_cumulative

FROM

dataset.table

SELECT id , date , price -- 累積金額の算出　id単位でdate順に並べ替えて、priceを累積していく , SUM(price) OVER (PARTITION BY id ORDER BY sales_date ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as price_cumulative FROM dataset.table

SELECT
    id
    , date
    , price
    -- 累積金額の算出　id単位でdate順に並べ替えて、priceを累積していく
    , SUM(price) OVER (PARTITION BY id ORDER BY sales_date ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as price_cumulative
FROM
    dataset.table