Sollicitatievraag bij Fabfurnish.com
delete duplicate data from a table using single query
Antwoord op sollicitatievraag
Anoniem
18 sep 2015
delete from table where id not in ( select count(*) c , id from table group by id having c > 1 )
delete duplicate data from a table using single query
Anoniem
delete from table where id not in ( select count(*) c , id from table group by id having c > 1 )