Window

FIRST_VALUE

BigQuery

Mengembalikan nilai pertama dalam window frame untuk setiap baris.

Tipe hasil: Same as input expressionDiperbarui: 7 Jan 2026

Syntax

SQL

FIRST_VALUE(expression) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression [frame_clause])

Parameter

expressionanywajib

Kolom atau ekspresi yang nilainya diambil

PARTITION BYexpressionopsional

Membagi data ke dalam grup

ORDER BYexpressionopsional

Menentukan urutan untuk menentukan nilai pertama

Contoh Penggunaan

Harga Pembukaan per Saham

SQL

1 SELECT
2   symbol,
3   date,
4   price,
5   FIRST_VALUE(price) OVER (PARTITION BY symbol ORDER BY date) as opening_price,
6   price - FIRST_VALUE(price) OVER (PARTITION BY symbol ORDER BY date) as change_from_open
7 FROM `project.dataset.stock_prices`;

Membandingkan harga saat ini dengan harga pembukaan.

Hasil

symbol	date	price	opening_price	change_from_open
GOOG	2024-01-01	100	100	0
GOOG	2024-01-02	105	100	5
GOOG	2024-01-03	103	100	3

First Purchase per Customer

SQL

1 SELECT
2   customer_id,
3   order_date,
4   amount,
5   FIRST_VALUE(order_date) OVER (PARTITION BY customer_id ORDER BY order_date) as first_order_date
6 FROM `project.dataset.orders`;

Tanggal order pertama untuk setiap customer.

Fungsi Terkait

LAGLEADLAST_VALUENTH_VALUE

Kembali ke BigQuery Functions

1	SELECT
2	symbol,
3	date,
4	price,
5	FIRST_VALUE(price) OVER (PARTITION BY symbol ORDER BY date) as opening_price,
6	price - FIRST_VALUE(price) OVER (PARTITION BY symbol ORDER BY date) as change_from_open
7	FROM `project.dataset.stock_prices`;

1	SELECT
2	customer_id,
3	order_date,
4	amount,
5	FIRST_VALUE(order_date) OVER (PARTITION BY customer_id ORDER BY order_date) as first_order_date
6	FROM `project.dataset.orders`;