Ameriprise Interview Question: How to get duplicate data from a table and delete those duplicate records

Notifications

Ameriprise

How to get duplicate data from a table and delete those duplicate records

Anonymous

5 Feb 2018

Delete from tablename where rowid not in (select max(rowid) from tabname groupby colname) Colname in groupby will be a primary key column

Anonymous

12 Aug 2018

Delete from tablename where rowid not in (select min (rowid) from tabname groupby colname)