Window

MAX_WINDOW

Snowflake

Mencari nilai maksimum dalam window frame. Berguna untuk tracking historical highs.

Tipe hasil: Same as input

Syntax

SQL

MAX(expression) OVER ([PARTITION BY ...] [ORDER BY ...])

Parameter

expressionANYwajib

Column yang akan dicari maksimumnya

Contoh Penggunaan

Track All-Time High

SQL

1 SELECT
2   date,
3   price,
4   MAX(price) OVER (ORDER BY date) as all_time_high,
5   CASE WHEN price = MAX(price) OVER (ORDER BY date)
6        THEN 'NEW HIGH' ELSE '' END as flag
7 FROM stock_prices;

Track all-time high dan tandai new highs.

Kembali ke Snowflake Functions

1	SELECT
2	date,
3	price,
4	MAX(price) OVER (ORDER BY date) as all_time_high,
5	CASE WHEN price = MAX(price) OVER (ORDER BY date)
6	THEN 'NEW HIGH' ELSE '' END as flag
7	FROM stock_prices;