have a look at this

create table #t1 (id int, status varchar(10), tme time)

insert into #t1 select 1,'started','07:00' union all

select 1,'running','08:00' union all

select 1,'completed','09:00' union all

select 2,'started','10:00' union all

select 2,'running','11:00'

;with cts

as (

select id,max(tme) tm from #t1

group by id)

select a.* from #t1 a inner join

cts b on a.id=b.id and tm=tme

order by a.id