create table emp(eno int,empname varchar(50),sal bigint)
insert into emp values('101','James','45000')insert into emp values('101','James','45000')insert into emp values('102','mike','12000')insert into emp values('102','mike','45000')insert into emp values('102','mike','45000')insert into emp values('103','Andrew','12000')
SELECT empname, COUNT(*) FROM emp GROUP BY empname HAVING COUNT(*) > 1
WITH tempTable as(SELECT ROW_NUMBER() Over(PARTITION BY eno,empname ORDER BY eno) As RowNumber,* FROM emp)select * from tempTable where RowNumber >1
WITH tempTable as(SELECT ROW_NUMBER() Over(PARTITION BY eno,empname ORDER BY eno) As RowNumber,* FROM emp)DELETE FROM tempTable where RowNumber >1