Window

NTH_VALUE

SnowflakeSnowflake

Mengembalikan nilai ke-N dalam window frame.

Tipe hasil: Same as inputDiperbarui: 6 Jan 2026

Syntax

SQL
NTH_VALUE(expr, n) OVER ([PARTITION BY ...] ORDER BY ... [frame])

Parameter

expranywajib

Expression untuk diambil nilainya

nINTEGERwajib

Posisi nilai yang diinginkan (1-based)

Contoh Penggunaan

Get Second Value

SQL
1SELECT
2  department,
3  employee_name,
4  salary,
5  NTH_VALUE(employee_name, 2) OVER (
6    PARTITION BY department
7    ORDER BY salary DESC
8    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9  ) as second_highest_paid
10FROM employees;

Karyawan dengan salary tertinggi kedua per department.

Kembali ke Snowflake Functions