Window

FIRST_VALUE

Snowflake

Mengembalikan nilai pertama dalam window frame.

Tipe hasil: Same as inputDiperbarui: 6 Jan 2026

Syntax

SQL

FIRST_VALUE(expr) OVER ([PARTITION BY ...] ORDER BY ... [frame])

Parameter

expranywajib

Expression untuk diambil nilainya

Contoh Penggunaan

First Order Date per Customer

SQL

1 SELECT
2   customer_id,
3   order_date,
4   amount,
5   FIRST_VALUE(order_date) OVER (
6     PARTITION BY customer_id
7     ORDER BY order_date
8   ) as first_order
9 FROM orders;

Tanggal order pertama per customer.

Compare to First

SQL

1 SELECT
2   date,
3   stock_price,
4   stock_price - FIRST_VALUE(stock_price) OVER (ORDER BY date) as change_from_start
5 FROM stock_prices;

Perubahan dari harga awal.

Fungsi Terkait

LAGLEADLAST_VALUENTH_VALUE

Kembali ke Snowflake Functions

1	SELECT
2	customer_id,
3	order_date,
4	amount,
5	FIRST_VALUE(order_date) OVER (
6	PARTITION BY customer_id
7	ORDER BY order_date
8	) as first_order
9	FROM orders;

1	SELECT
2	date,
3	stock_price,
4	stock_price - FIRST_VALUE(stock_price) OVER (ORDER BY date) as change_from_start
5	FROM stock_prices;