Window

LAST_VALUE

MySQL

Mengembalikan nilai terakhir dalam window frame. Perlu frame clause yang tepat untuk seluruh partition.

Tipe hasil: Same as exprDiperbarui: 7 Jan 2026

Syntax

SQL

LAST_VALUE(expr) OVER ([PARTITION BY col] ORDER BY col [frame_clause])

Parameter

exprexpressionwajib

Kolom atau ekspresi yang diambil nilainya

ORDER BYcolumn(s)wajib

Kolom untuk menentukan urutan

PARTITION BYcolumn(s)opsional

Kolom untuk membagi data menjadi grup (opsional)

Contoh Penggunaan

Harga Penutup

SQL

1 SELECT date, price,
2   LAST_VALUE(price) OVER (
3     ORDER BY date
4     ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
5   ) AS closing_price
6 FROM stock_prices;

Mendapatkan harga penutup (terakhir).

Hasil

(prices with closing price)

Nilai Terbaru per Grup

SQL

1 SELECT category, month, revenue,
2   LAST_VALUE(revenue) OVER (
3     PARTITION BY category 
4     ORDER BY month
5     ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
6   ) AS latest_revenue
7 FROM sales;

Revenue terakhir per kategori.

Hasil

(revenue with latest per category)

Gap dari Target

SQL

1 SELECT date, actual,
2   LAST_VALUE(actual) OVER (
3     ORDER BY date
4     ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
5   ) - actual AS gap_to_final
6 FROM progress;

Jarak ke nilai final.

Hasil

(gap to final value)

Fungsi Terkait

LAGLEADFIRST_VALUENTH_VALUE

Kembali ke MySQL Functions

1	SELECT date, price,
2	LAST_VALUE(price) OVER (
3	ORDER BY date
4	ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
5	) AS closing_price
6	FROM stock_prices;

1	SELECT category, month, revenue,
2	LAST_VALUE(revenue) OVER (
3	PARTITION BY category
4	ORDER BY month
5	ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
6	) AS latest_revenue
7	FROM sales;

1	SELECT date, actual,
2	LAST_VALUE(actual) OVER (
3	ORDER BY date
4	ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
5	) - actual AS gap_to_final
6	FROM progress;