How to delete duplicate records in SQL

Question

delete from EmpDup where EmpID in(select EmpID from EmpDup group by EmpId having
count(*) >1)

Answer 1

That'll delete all the repeated occurrences, not leave a unique record for each one of them. Is this what you wanted?

Answer 2

Use ROWID....
delete from EmpDup where rowid in (select max(rowid) from EmpDup group by EmpId having
count(*) >1);