create table temp(id int,path varchar(1024))
go
insert into temp values(1,'C:\my\')
insert into temp values(2,'C:\my\')
insert into temp values(3,'C:\my\')
insert into temp values(4,'C:\my\')
insert into temp values(5,'C:\my\')
go

with cteRow(id,path,Rownum)
as
(
   Select id,path,row_number() over(partition by path order by id)
      from temp
)
delete from cteRow
where Path = 'C:\my\'
and Rownum <> 1
select * from temp

DELETE TOP (SELECT COUNT(*)-1 FROM temp WHERE path='C:\my\' ) FROM temp WHERE path='C:\my\'