以下是BigQuery标准SQL
#standardSQLSELECt * EXCEPT(grp), SUM(Expected_reached) OVER(PARTITION BY grp ORDER BY `date`) Running_TotalFROM ( SELECt *, COUNTIF(Expected_reached = 0) OVER(ORDER BY `date`) grp FROM `project.dataset.table`)
以下是BigQuery标准SQL
#standardSQLSELECt * EXCEPT(grp), SUM(Expected_reached) OVER(PARTITION BY grp ORDER BY `date`) Running_TotalFROM ( SELECt *, COUNTIF(Expected_reached = 0) OVER(ORDER BY `date`) grp FROM `project.dataset.table`)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
