Window

CONDITIONAL_CHANGE_EVENT

Snowflake

Menghitung berapa kali nilai berubah dalam window.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

CONDITIONAL_CHANGE_EVENT(expr) OVER ([PARTITION BY ...] ORDER BY ...)

Parameter

expranywajib

Expression untuk ditrack perubahannya

Contoh Penggunaan

Track Status Changes

SQL

1 SELECT
2   order_id,
3   status,
4   updated_at,
5   CONDITIONAL_CHANGE_EVENT(status) OVER (
6     PARTITION BY order_id
7     ORDER BY updated_at
8   ) as status_change_num
9 FROM order_status_log;

Melacak berapa kali status berubah.

Kembali ke Snowflake Functions

1	SELECT
2	order_id,
3	status,
4	updated_at,
5	CONDITIONAL_CHANGE_EVENT(status) OVER (
6	PARTITION BY order_id
7	ORDER BY updated_at
8	) as status_change_num
9	FROM order_status_log;