It is easy to delete records by considering two colmns

create table #Test

(EmpID VARCHAR(8),

EmpName varchar(50))

insert into #Test VALUES('abc','Daya')

insert into #Test values('abc','Daya')

insert into #Test values('def','Daya')

;WITH Emp AS (SELECT ROW_NUMBER ( ) OVER ( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RNUM FROM #Test )

DELETE FROM Emp WHERE RNUM > 1

select * FROM #Test

Output

EmpIDEmpName

abcDaya

defDaya