I'm looking for the most efficient way to remove duplicates from a table where id's are unique but there are equal rows when you check other columns.
id name age x 1 peter 25 II 2 peter 25 II
The table has tens of thousands of rows.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Supposing you have no foreign keys referencing that table, you could do something like
create table some_table as select min(id), name, age, x from t group by name, age, x
then you can drop the old table, rename the new table so that it has the same name as the old one before, and create indexes and other things you need on that table.