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...