윈도우 프레임의 마지막 값을 반환합니다.
문법
LAST_VALUE(expr) OVER (w)예제
아래 값을 입력하면 예제에 즉시 반영됩니다.
employee_id→salary→hire_date→last_hired_salary→employees→SELECT employee_id, salary,
LAST_VALUE(salary) OVER (
ORDER BY hire_date
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
) AS last_hired_salary
FROM employees;