|
SQL> select
2 emp_id,dept_id,row_number
3 from
4 ( select
5 emp_id, dept_id,
6 row_number()
7 over( partition by dept_id order by emp_id ) as row_number
8 from emp01 )
9 where row_number <= 2;
EMP_ID DEPT_ID ROW_NUMBER
----- ----- ----------
E01 D01 1
E02 D02 1
E04 D02 2
E03 D03 1
E05 D03 2
|