SQL Server 2019

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

create table junk(Application varchar(10), Version varchar(5), something char(1), DateCreated date);
insert into junk values('7-Zip','60.0','x','09/25/2019');
insert into junk values('7-Zip','60.0','y','12/26/2019');
insert into junk values('Xmind','23','x','05/23/2019');
insert into junk values('Xmind','23','y','01/01/2020');
4 rows affected

select Application, Version, DateCreated from (
	select Application, Version, DateCreated, row_number() over(Partition by Application order by DateCreated desc) rn
	from junk
) x
where rn=1


Application
Version
DateCreated


7-Zip
60.0
2019-12-26

Xmind
23
2020-01-01


SELECT DISTINCT t1.Application,t1.Version,t1.datecreated FROM junk t1
WHERE t1.datecreated = (SELECT Max(t2.datecreated) FROM junk t2 WHERE t2.Application=t1.Application)


Application
Version
datecreated


7-Zip
60.0
2019-12-26

Xmind
23
2020-01-01