Last_Value1.htm
Oracle : PostgreSQL : (MySQL won't support)

Last_Value: returns value evaluated at the row that is the last row of the window frame

select last_value(t1.sal) over(order by t1.sal)as lv, t1.* from emp t1 order by t1.sal
emp Table;

Oracle: 

PostgreSQL: