Window

FIRST_VALUE

MySQL

Mengembalikan nilai pertama dalam window frame. Berguna untuk mendapatkan nilai awal atau baseline.

Tipe hasil: Same as exprDiperbarui: 7 Jan 2026

Syntax

SQL

FIRST_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 Pembuka

SQL

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

Mendapatkan harga pembuka (pertama).

Hasil

(prices with opening price)

Baseline per Kategori

SQL

1 SELECT category, month, revenue,
2   FIRST_VALUE(revenue) OVER (
3     PARTITION BY category 
4     ORDER BY month
5   ) AS baseline
6 FROM sales;

Revenue bulan pertama per kategori.

Hasil

(revenue with category baseline)

Perbandingan dari Awal

SQL

1 SELECT date, amount,
2   amount - FIRST_VALUE(amount) OVER (ORDER BY date) AS diff_from_start
3 FROM daily_metrics;

Selisih dari nilai awal.

Hasil

(difference from initial value)

Fungsi Terkait

LAGLEADLAST_VALUENTH_VALUE

Kembali ke MySQL Functions

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

1	SELECT category, month, revenue,
2	FIRST_VALUE(revenue) OVER (
3	PARTITION BY category
4	ORDER BY month
5	) AS baseline
6	FROM sales;

1	SELECT date, amount,
2	amount - FIRST_VALUE(amount) OVER (ORDER BY date) AS diff_from_start
3	FROM daily_metrics;