Window
BigQuery
LEAD
BigQueryAccesses a value from a subsequent row in the partition based on the specified offset.
Tipe hasil:
Same as input expressionDiperbarui: 13 Jun 2026Syntax
SQL
LEAD(expression [, offset [, default_value]]) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression)Parameter
expressionanywajib
Column or expression whose value is retrieved
ORDER BYexpressionwajib
Determines the row ordering
offsetINT64opsional
Number of rows to look ahead (default: 1)
Default: 1
default_valuesame as expressionopsional
Value returned when no next row exists
Contoh Penggunaan
View Next Event
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`;
Calculates the time until the next event.
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`;
Shows the next page visited by the user.
Pertanyaan Umum tentang LEAD
Apa itu fungsi LEAD di BigQuery?
Accesses a value from a subsequent row in the partition based on the specified offset. Di BigQuery, fungsi LEAD termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan LEAD di BigQuery?
Gunakan sintaks berikut: LEAD(expression [, offset [, default_value]]) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi LEAD?
Fungsi LEAD 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.
Apa saja parameter fungsi LEAD?
Fungsi ini memiliki 2 parameter wajib dan 2 parameter opsional. Parameter yang digunakan: expression (any, wajib): Column or expression whose value is retrieved; offset (INT64, opsional): Number of rows to look ahead (default: 1); default_value (same as expression, opsional): Value returned when no next row exists; ORDER BY (expression, wajib): Determines the row ordering.
Fungsi Terkait
Ngulik Langsung
Latihan Langsung →Sudah paham LEAD? Latih langsung di browser
Latihan interaktif, langsung di browser.