How to find and delete duplicate records in a table ?

For that Firstly check if table has duplicate records or not , using below query SELECT firstName FROM emp GROUP BY firstName
  HAVING COUNT(*) > 1
Then Delete duplicate records DELETE FROM emp WHERE id NOT IN (
  SELECT MAX(id) FROM emp GROUP BY firstName )