Window

LAST_VALUE

Q: Apa saja parameter fungsi LAST_VALUE?

Fungsi ini memiliki 1 parameter wajib dan 2 parameter opsional. Parameter yang digunakan: expression (any, wajib): Column or expression whose value is retrieved; PARTITION BY (expression, opsional): Divides data into groups; ORDER BY (expression, opsional): Determines the ordering.

BigQuery

Returns the last value in the window frame for each row.

Tipe hasil: Same as input expressionDiperbarui: 13 Jun 2026

Syntax

SQL

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

Parameter

expressionanywajib

Column or expression whose value is retrieved

PARTITION BYexpressionopsional

Divides data into groups

ORDER BYexpressionopsional

Determines the ordering

Contoh Penggunaan

Last Value with Full Frame

SQL

1 SELECT
2   department,
3   name,
4   salary,
5   LAST_VALUE(name) OVER (
6     PARTITION BY department
7     ORDER BY salary
8     ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9   ) as highest_paid
10 FROM `project.dataset.employees`;

Finds the highest-paid employee per department.

Hasil

department	name	salary	highest_paid
Sales	David	50000	Alice
Sales	Bob	80000	Alice
Sales	Alice	120000	Alice

Latest Status per Order

SQL

1 SELECT
2   order_id,
3   status,
4   updated_at,
5   LAST_VALUE(status) OVER (
6     PARTITION BY order_id
7     ORDER BY updated_at
8     ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9   ) as current_status
10 FROM `project.dataset.order_history`;

Gets the most recent status for each order.

Pertanyaan Umum tentang LAST_VALUE

Apa itu fungsi LAST_VALUE di BigQuery?

Returns the last value in the window frame for each row. Di BigQuery, fungsi LAST_VALUE termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan LAST_VALUE di BigQuery?

Gunakan sintaks berikut: LAST_VALUE(expression) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression [frame_clause]). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi LAST_VALUE?

Fungsi LAST_VALUE mengembalikan nilai bertipe Same as input expression. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Fungsi Terkait

LAGLEADFIRST_VALUENTH_VALUE

Ngulik Langsung

Sudah paham LAST_VALUE? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	department,
3	name,
4	salary,
5	LAST_VALUE(name) OVER (
6	PARTITION BY department
7	ORDER BY salary
8	ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9	) as highest_paid
10	FROM `project.dataset.employees`;

1	SELECT
2	order_id,
3	status,
4	updated_at,
5	LAST_VALUE(status) OVER (
6	PARTITION BY order_id
7	ORDER BY updated_at
8	ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9	) as current_status
10	FROM `project.dataset.order_history`;