Window

LEAD

BigQuery

Mengakses nilai dari baris berikutnya dalam partition berdasarkan offset yang ditentukan.

Tipe hasil: Same as input expressionDiperbarui: 7 Jan 2026

Syntax

SQL

LEAD(expression [, offset [, default_value]]) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression)

Parameter

expressionanywajib

Kolom atau ekspresi yang nilainya diambil

ORDER BYexpressionwajib

Menentukan urutan baris

offsetINT64opsional

Jumlah baris ke depan (default: 1)

Default: 1

default_valuesame as expressionopsional

Nilai jika tidak ada baris berikutnya

Contoh Penggunaan

Melihat Event Berikutnya

SQL

1 SELECT
2   event_time,
3   event_type,
4   LEAD(event_time) OVER (ORDER BY event_time) as next_event_time,
5   TIMESTAMP_DIFF(LEAD(event_time) OVER (ORDER BY event_time), event_time, SECOND) as seconds_to_next
6 FROM `project.dataset.user_events`;

Menghitung waktu sampai event berikutnya.

Hasil

event_time	event_type	next_event_time	seconds_to_next
2024-01-01 10:00:00	click	2024-01-01 10:05:00	300
2024-01-01 10:05:00	purchase	2024-01-01 10:30:00	1500
2024-01-01 10:30:00	logout	NULL	NULL

Session Analysis

SQL

1 SELECT
2   user_id,
3   page,
4   LEAD(page) OVER (PARTITION BY user_id ORDER BY timestamp) as next_page
5 FROM `project.dataset.pageviews`;

Melihat halaman berikutnya yang dikunjungi user.

Fungsi Terkait

LAGFIRST_VALUELAST_VALUENTH_VALUE

Kembali ke BigQuery Functions

1	SELECT
2	event_time,
3	event_type,
4	LEAD(event_time) OVER (ORDER BY event_time) as next_event_time,
5	TIMESTAMP_DIFF(LEAD(event_time) OVER (ORDER BY event_time), event_time, SECOND) as seconds_to_next
6	FROM `project.dataset.user_events`;

1	SELECT
2	user_id,
3	page,
4	LEAD(page) OVER (PARTITION BY user_id ORDER BY timestamp) as next_page
5	FROM `project.dataset.pageviews`;