You can do it with where condition.
Refer below query.
SQL
DECLARE @DSR AS TABLE(Com VARCHAR(15),DC VARCHAR(10))
INSERT INTO @DSR VALUES('Company1','4/5/2021')
INSERT INTO @DSR VALUES('Company2','5/6/2021')
INSERT INTO @DSR VALUES('Company3','5/6/2021')
INSERT INTO @DSR VALUES('Company3','5/8/2021')
INSERT INTO @DSR VALUES('Company5','5/9/2021')
INSERT INTO @DSR VALUES('Company4','5/9/2021')
INSERT INTO @DSR VALUES('Company2','5/9/2021')
INSERT INTO @DSR VALUES('Company6','3/9/2021')
INSERT INTO @DSR VALUES('Company7','2/9/2021')
INSERT INTO @DSR VALUES('Company8','1/9/2021')
INSERT INTO @DSR VALUES('Company9','11/9/2020')
INSERT INTO @DSR VALUES('Company8','5/10/2021')
SELECT * FROM @DSR WHERE DC IN (SELECT MAX(DC) DC FROM DSR GROUP BY Com) AND DATEDIFF(DAY,DC,GETDATE()) >= 120 ORDER BY DC ASC
Output
Com DC
Company9 11/9/2020
