SQL Server 2017

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

create table t (id int ,name varchar(100),place varchar(200),date1 date);
insert into t values(1238,'Amin','us','1996-05-01'),
(1230,'James','us','1998-05-01'),
(1230,'James','us','2011-05-01'),
(1211,'Rudlof','us','2002-05-01'),
(1211,'Rudlof','us','2010-05-01');

5 rows affected

select top 1 PERCENT WITH TIES * from t
order by (row_number() over(partition by id order by date1 desc))


id
name
place
date1


1211
Rudlof
us
2010-05-01

1230
James
us
2011-05-01

1238
Amin
us
1996-05-01

id	name	place	date1
1211	Rudlof	us	2010-05-01
1230	James	us	2011-05-01
1238	Amin	us	1996-05-01