How to remove duplicate values from SQL table

Below SQL queries will helpful to remove duplicate values from sql table: 1.  DELETE FROM table WHERE ID IN ( SELECT  ID, COUNT(ID)  FROM   table G…