SQL> select
2 emp_id, dept_id, salary,
3 first_value( salary )
4 over( partition by dept_id order by salary desc ) as first_salary
5 from emp01;
EMP_ID DEPT_ID SALARY FIRST_SALARY
----- ----- ------- ----------
E01 D01 150 150
E06 D02 600 600
E04 D02 400 600
E02 D02 200 600
E05 D03 500 500
E03 D03 300 500 |