-- Delete dulpicate records from table.

- 1st Case: - delete all duplicate records

delete e1 from emp3 e1, emp3 e2 where e1.name=e2.name and e1.id <> e2.id;

- 2nd Case: - delete all duplicate records with remain lowest id (previous record)

- delete e1 from emp3 e1, emp3 e2 where e1.name=e2.name and e1.id > e2.id;

- 3rd Case: - delete all duplicate records with remain highest id (latest record)

- delete e1 from emp3 e1, emp3 e2 where e1.name=e2.name and e1.id < e2.id;