select top 1 with ties
[id], [ФИО], [Дата], [Проходная], [транспорт]
from
table1
order by
row_number()over(partition by [ФИО] order by [Дата] desc)

declare @t table(id
                 , ФИО primary key clustered with( IGNORE_DUP_KEY = ON )
                 , Дата Проходная транспорт
                  );
                  
insert  @t select * from [Есть таблица] order by Дата DESC;
 
select * from @t;