Last_Value: returns value evaluated at the row that is the last row of the window frame
| 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:
|