Window

SUM_WINDOW

Snowflake

Menghitung running sum atau cumulative sum menggunakan window function.

Tipe hasil: NUMERIC

Syntax

SQL

SUM(expression) OVER ([PARTITION BY ...] [ORDER BY ...] [frame_clause])

expressionNUMERICwajib

Kolom numerik yang akan dijumlahkan

SQL

1 SELECT
2   date,
3   revenue,
4   SUM(revenue) OVER (ORDER BY date) as running_total,
5   SUM(revenue) OVER () as grand_total
6 FROM daily_revenue;

Running total vs grand total.

Hasil

date	revenue	running_total	grand_total
2024-01-01	1000	1000	6000
2024-01-02	1500	2500	6000
2024-01-03	2000	4500	6000
2024-01-04	1500	6000	6000

1	SELECT
2	date,
3	revenue,
4	SUM(revenue) OVER (ORDER BY date) as running_total,
5	SUM(revenue) OVER () as grand_total
6	FROM daily_revenue;