Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create Table tbl_name(Date_ DATE, Dept INT, Employee VARCHAR(50));
Insert All Into tbl_name Values('21-Aug-2022',2,'John')
Into tbl_name Values('21-Aug-2022',1,'Meredith')
Into tbl_name Values('21-Aug-2022',9,'Steve')
Into tbl_name Values('21-Aug-2022',0,'Bella')
Select 1 From DUAL;
4 rows affected

With CTE As
(
  Select Date_, Dept, Employee, 
         ROW_NUMBER() Over (Order By Date_ DESC, Employee) rn
  From tbl_name
) 
Select Date_, Dept, Employee
From CTE
Where rn >= (Select rn From CTE Where Dept = 0)
FETCH NEXT 2 ROWS ONLY;


DATE_
DEPT
EMPLOYEE


21-AUG-22
0
Bella

21-AUG-22
2
John