SQL Server 2019

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

create table mytable (mydate date, myfile varchar(50), device varchar(50))

insert into mytable (mydate, myfile, device) values
('20220909', 'Acrobat.exe', 'ABC123'),
('20220910', 'Acrobat.exe', 'DEF456'),
('20211107', 'Visio.exe', 'ABC123'),
('20201231', 'Acrobat.exe', 'ABC123')

select * from mytable


mydate
myfile
device


2022-09-09
Acrobat.exe
ABC123

2022-09-10
Acrobat.exe
DEF456

2021-11-07
Visio.exe
ABC123

2020-12-31
Acrobat.exe
ABC123


select max(t.mydate) as [date],
       t.myfile,
       t.device
from   mytable t
group by t.myfile, t.device
order by t.myfile


date
myfile
device


2022-09-09
Acrobat.exe
ABC123

2022-09-10
Acrobat.exe
DEF456

2021-11-07
Visio.exe
ABC123


drop table mytable

mydate	myfile	device
2022-09-09	Acrobat.exe	ABC123
2022-09-10	Acrobat.exe	DEF456
2021-11-07	Visio.exe	ABC123
2020-12-31	Acrobat.exe	ABC123