Question d’entretien chez Capgemini
write an SQL query to delete duplicates from a tablw?
Réponse à la question d'entretien
Utilisateur anonyme
7 juil. 2021
Use the rowid pseudocolumn. DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3);