Fabfurnish.com Interview Question
delete duplicate data from a table using single query
Interview Answer
Anonymous
Sep 18, 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.