declare @ForDuplicates table  (id int, name varchar(20))
insert into @ForDuplicates values (1,'RAM'),(2,'LAXMAN'),(3,'YUDHI'),(1,'RAMA')

select *, ROW_NUMBER() OVER(PARTITION BY id ORDER BY id DESC)  Rn
 from @ForDuplicates
 
 
;with cteGig(id, name, rn)
AS
(
select *, ROW_NUMBER() OVER(PARTITION BY id ORDER BY id DESC)  Rn
 from @ForDuplicates
 )
select * from cteGig where rn = 1

DELETE A
FROM
(
	select *, ROW_NUMBER() OVER(PARTITION BY id ORDER BY id DESC)  Rn
	 from @ForDuplicates
 ) AS A
where rn <> 1