←
FIRSTLASTWindow Functions
Applies an aggregate function to the last group in the sorted order.
Syntax
agg_fn() KEEP (DENSE_RANK LAST ORDER BY ...)Example
Enter values below to update the example in real time.
salary→hire_date→latest_hire_salary→employees→SELECT MAX(salary) KEEP (DENSE_RANK LAST ORDER BY hire_date) AS latest_hire_salary
FROM employees;