Delete duplicate record from database table

• Query 1

          DELETE FROM table_name WHERE id NOT IN ( SELECT MAX(ID) FROM table_name GROUP BY duplicate_col_1, duplicate_col_2, duplicate_col_3)

• Query 2

          CREATE TABLE AS new_table_name AS SELECT DISTINCT * FROM original_table_name;
          DROP TABLE original_table_name;
          RENAME new_table_name TO original_table_name;