您可以使用条件总和创建子组：
WITH cte AS ( SELECt t.*,SUM(CASE WHEN hour=3 THEN 1 ELSE 0 END) OVER(ORDER BY timestamp) grp FROM t)SELECt cte.*, SUM(Count) OVER(PARTITION BY grp ORDER BY timestamp) AS totalFROM cte
您可以使用条件总和创建子组：
WITH cte AS ( SELECt t.*,SUM(CASE WHEN hour=3 THEN 1 ELSE 0 END) OVER(ORDER BY timestamp) grp FROM t)SELECt cte.*, SUM(Count) OVER(PARTITION BY grp ORDER BY timestamp) AS totalFROM cte
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
