Fabfurnish.com interview question
delete duplicate data from a table using single query
Interview Answer
Anonymous
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
Anonymous
delete from table where id not in ( select count(*) c , id from table group by id having c > 1 )
Check out your Company Bowl for anonymous work chats.