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('18-Aug-2022',2,'John')
Into tbl_name Values('19-Aug-2022',1,'Meredith')
Into tbl_name Values('20-Aug-2022',9,'Steve')
Into tbl_name Values('21-Aug-2022',0,'Bella')
Select 1 From DUAL;
4 rows affected

Select D.Date_, D.Dept, D.Employee
From tbl_name D
Where D.Date_ <= (Select Date_ From tbl_name Where Dept = 0)
Order By Date_ DESC
FETCH NEXT 2 ROWS ONLY;


DATE_
DEPT
EMPLOYEE


21-AUG-22
0
Bella

20-AUG-22
9
Steve