Find Duplicate Column's Records And Delete Duplicate Records in Sql Server

Query : Find Duplicate Record From Table


select EmpSalary, count(*) TotalCount from Employee
group by EmpSalary having count(*) > 1 order by count(*) asc




Query : Delete Duplicate Record From Table



delete Employee where EmpId NOT IN
(select MIN(EmpId) from Employee group by EmpSalary)