0

More than 3 years have passed since last update.

SQL:累積処理

SQL

Last updated at 2020-02-23Posted at 2020-02-23

SUM (seconds) OVER (PARTITION BY item ORDER BY start_time) AS xxxx

累積時間の計算。

SELECT duration_seconds,
       SUM(duration_seconds) OVER (ORDER BY start_time) AS running_total
  FROM tutorial.dc_bikeshare_q1_2012

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0