Delete duplicate records from Table

DELETE FROM item_master_2017
WHERE id IN (
    SELECT * FROM (
        SELECT id FROM item_master_2017 GROUP BY item_code HAVING (COUNT(*) > 1)
            )
            AS A
         );