Frage im Vorstellungsgespräch bei Fabfurnish.com

delete duplicate data from a table using single query

Antwort im Vorstellungsgespräch

Anonym

18. Sept. 2015

delete from table where id not in ( select count(*) c , id from table group by id having c > 1 )