SQL在定义的时间范围内将累加值分解为单个值

WITH data_with_cumulative AS (
  SELECT
    t.date,
    t.value,
    SUM(t.value) OVER (ORDER BY t.date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_value
  FROM
    your_table t
  WHERE
    t.date >= 'start_date' AND t.date <= 'end_date'
)
SELECT
  date,
  value
FROM
  data_with_cumulative
WHERE
  cumulative_value > 0
ORDER BY
  date;