Execute the following query for each duplicate value.

1.Delete duplicate of empname='A'

delete top(select count(*)-1 from employee where
empname='A') from employee where empname='A'

2.Delete duplicate of empname='D'

delete top(select count(*)-1 from employee where
empname='D') from employee where empname='D'

declare  myCursor cursor for
select empid
				from employee 
				group by empid
				having count(*) > 1

declare @EmpId int


OPEN myCursor;
		FETCH NEXT FROM myCursor INTO @EmpId
		WHILE @@FETCH_STATUS = 0
		BEGIN

		delete top(select count(*)-1 from employee where
		empid=@EmpId) from employee where empid=@EmpId

FETCH NEXT FROM myCursor INTO @EmpId
		END
close myCursor  

deallocate myCursor