Domanda di colloquio di Fabfurnish.com
delete duplicate data from a table using single query
Risposta di colloquio
Anonimo
18 set 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
Anonimo
delete from table where id not in ( select count(*) c , id from table group by id having c > 1 )