Removing duplicates from table without using Distinct
Respostas da entrevista
Sigiloso
6 de mai. de 2018
Using group by
Sigiloso
7 de jul. de 2018
DELETE * from table1 where rowId not in( Select min(rowId), column1, column2 from table1 group by column1, column2 having count(1) > 1 ).
If you want to classify the duplicates those rows that have the same value for these columns.