Window

LEAD

MySQL

Mengakses nilai dari baris berikutnya dalam partition. Kebalikan dari LAG.

Tipe hasil: Same as exprDiperbarui: 7 Jan 2026

Syntax

SQL

LEAD(expr [, offset [, default]]) OVER ([PARTITION BY col] ORDER BY col)

Parameter

exprexpressionwajib

Kolom atau ekspresi yang diambil nilainya

ORDER BYcolumn(s)wajib

Kolom untuk menentukan urutan

offsetintegeropsional

Jumlah baris ke depan (default 1)

Default: 1

defaultanyopsional

Nilai jika tidak ada baris berikutnya (default NULL)

Contoh Penggunaan

Nilai Berikutnya

SQL

1 SELECT date, price,
2   LEAD(price) OVER (ORDER BY date) AS next_price
3 FROM stock_prices;

Mengambil harga hari berikutnya.

Hasil

(prices with next day value)

Waktu ke Event Berikut

SQL

1 SELECT event_time, event_type,
2   TIMESTAMPDIFF(SECOND, event_time, 
3     LEAD(event_time) OVER (ORDER BY event_time)
4   ) AS seconds_to_next
5 FROM user_events;

Menghitung waktu antara events.

Hasil

(time between consecutive events)

Deadline Alert

SQL

1 SELECT task, due_date,
2   CASE WHEN LEAD(due_date) OVER (ORDER BY due_date) 
3        = DATE_ADD(due_date, INTERVAL 1 DAY)
4   THEN 'Back-to-back!'
5   ELSE 'OK'
6   END AS alert
7 FROM tasks;

Cek jika deadline berturut-turut.

Hasil

(tasks with consecutive deadline alert)

Fungsi Terkait

LAGFIRST_VALUELAST_VALUENTH_VALUE

Kembali ke MySQL Functions

1	SELECT date, price,
2	LEAD(price) OVER (ORDER BY date) AS next_price
3	FROM stock_prices;

1	SELECT event_time, event_type,
2	TIMESTAMPDIFF(SECOND, event_time,
3	LEAD(event_time) OVER (ORDER BY event_time)
4	) AS seconds_to_next
5	FROM user_events;

1	SELECT task, due_date,
2	CASE WHEN LEAD(due_date) OVER (ORDER BY due_date)
3	= DATE_ADD(due_date, INTERVAL 1 DAY)
4	THEN 'Back-to-back!'
5	ELSE 'OK'
6	END AS alert
7	FROM tasks;