select first_value(t1.sal) over(order by t1.sal)as fv, t1.* from emp t1 order by t1.sal
PostgreSQL:
| First_Value1.htm |
| Oracle :PostgeSQL: (MySQL did not work) |
| Script:
select first_value(t1.sal) over(order by t1.sal)as fv, t1.* from emp t1 order by t1.sal |
| Oracle:
PostgreSQL:
|