SELECT empno,ename, sal, hiredate ,
LAST_VALUE(hiredate) OVER (ORDER BY sal ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
AS lv FROM (SELECT * FROM emp WHERE deptno = 20 ORDER BY hiredate)