Pregunta de entrevista de Fabfurnish.com
delete duplicate data from a table using single query
Respuesta de la entrevista
Anónimo
18 sept 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
Anónimo
delete from table where id not in ( select count(*) c , id from table group by id having c > 1 )