윈도우 프레임의 n번째 값을 반환합니다.
문법
NTH_VALUE(expr, n) OVER (w)예제
아래 값을 입력하면 예제에 즉시 반영됩니다.
department_id→employee_id→salary→second_highest→employees→SELECT department_id, employee_id, salary,
NTH_VALUE(salary, 2) OVER (
PARTITION BY department_id ORDER BY salary DESC
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
) AS second_highest
FROM employees;